Informatica Powercenter Development Training

Table of Content

Data Warehousing
• History, Advantages, Usage etc.
• Theoretical & Technical Architecture.
• Functions of DWH.
• Data Marts
o Data Mart concept
o Top Down Approach
o Bottom up Approach

Data Modeling
• Data Modeling Concepts.
• Dimension modeling & OLTP system.
• Dimension & Fact
• Schema generation
o Star & Snow Flake Schema
• SCD concepts (Slowly changing dimension)
o Type-1 SCD
o Type-2 SCD
o Type-3 SCD

• Data Acquisition
o Data Extraction
o Data Transformation
o Data Loading
• ETL Development Life Cycle
• Informatica Architecture
• Informatica Power center components & User Interface
• Different types of Sources & Targets
• Working with Database, Flat file.
• Basic Simple Pass mapping
• Use of Transformations:
o Source Qualifier T/R
o Sorter T/R
o Filter T/R
o Router T/R
o Rank T/R
o Expression T/R
o Sequence Generator T/R
o Aggregator T/R
o Union T/R
o Joiner T/R
o Lookup T/R
o Update Strategy T/R
o Normalizer T/R (Advanced concept)
• Different Types of Tasks
• Mapping Parameter & Mapping Variables

Advanced Concepts
• Loading text file in indirect method
• Working with Mapplet
• Working with Worklet
• Workflow Scheduling
• Batch Processing
• Session Parameter
• Mapping Debugger
• Target Load Plan
• SCD Type 1 & Type 2 implementation

Contact Us

We are always here to guide you...

Quick Enquiry

Please enter name.
Please enter name.
Please enter valid email adress.
Please enter Course name.
Please enter your comment.

+91 9619 3417 13

+91 7506 4114 34

Website :

We Are Social