Course Duration in Hours
40
40
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
Informatica
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