Informatica Online Training

Informatica Online Training

Informatica Online Training
Informatica Online Training

Informatica Online Training Course Content :

Informatica Power Center

  • Basic Concepts of Informatica
  • Overview Basic Definitions
  • Informatica Products, Architecture
  • Tools and their Roles
  • Power Center Vs Power Mart
  • Understanding Informatica Server Configuration

Informatica Designer

  • Basic Concepts
  • Using the Designer
  • Working with Sources
  • Working with Flat Files, Targets
  • Mappings, Transformations, Mapplets
  • Working with Debugger
  • Implementing Type 1, Type2, Type 3 Mappings
  • Loading the data into different fact tables

Working with Transformations

  • Aggregator Transformation
  • XML Transformation
  • Expression, Look up Transformation
  • Rank, Router, Filter, Sequence Generator
  • Sorter Transformation
  • Source Qualifier Transformation
  • Stored Procedure Transformation
  • Transaction Control Transformation
  • Joiner, Union Transformation
  • Java Transformation
  • SQL Transformation
  • XML Source Qualifier
  • Update Strategy Transformation
  • Mapplet Input Transformation
  • Mapplet Output Transformation
  • Connected Vs Unconnected Transformations

Creating Work flows

  • Understanding the server Architecture
  • Working with Workflows
  • Working with Tasks Assignment, Command, Decision, Control, Event Raise Event Wait, Timer , Email, Session Task
  • Working with Worklets
  • Working with Sessions
  • Understanding Commit Points
  • Understanding Commit Points
  • Monitoring Workflows
  • Session Parameters
  • Parameter files
  • Using Incremental Aggregation

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Reasons for using, uses
  • Characteristics of DWH
  • OLTP Vs OLAP Databases

Implementation Methodology

  • Kimball Methodology
  • Inmon Methodology

Types of Loads

  • First Time Load
  • Full Load
  • Incremental Load

Data Marts and Star Schema Design

  • Definition of Star Schema
  • Design of Dimension and Facts
  • Snow Flake Star Schema
  • Slowly Changing Dimensions
  • Non Additive Facts
  • Conformed Dimensions

Drop your query

What my Client's Say?


  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim