Session : 1 – Data Warehouse Introduction
Session : 2 – Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power Center Admin Console
Session : 3 – Informatica Concepts and Overview
- Informatica Architecture.
Sources
- Working with relational Sources
- Working with Flat Files
Session : 4 – Targets
- Working with Relational Targets
- Working with Flat file Targets
Session : 5 – Transformations – Active and Passive Transformations
- Expression
- Lookup –Different types of lookup Caches
- Sequence Generator
- Filter
- Joiner
- Sorter
- Rank
- Router
- Aggregator
- Source Qualifer
- Update Strategy
- Normalizer
- Union
- Stored Procedure
- Slowly Changing Dimension
- SCD Type1
- SCD Type2 — Date, Flag and Version
- SCD Type3
Session : 6 – Workflow Manger
- Creating Reusable tasks
- Workflows, Worklets & Sessions
- Tasks
- Session
- Decision task
- Control Task
- Event wait task
- Timer task
- Monitoring workflows and debugging errors
Session : 7 – Indirect Loading
Session : 8 – Constraint based load ordering
Session : 9 – Target Load plan
Session : 10 – Worklet ,Mapplet ,Resuable transformation
Session : 11 – Migration –XML migration and Folder Copy.
Session : 12 – Scheduling Workflow
Session : 13 – Parameter and variables
Session : 14 – XML Source, Target and Transformations
Session : 15 – Performance Tuning
- Pipeline Partition
- Dynamic Partition
- Pushdown optimization
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.