Learning Objectives: In this module of Informatica Training, we will discuss advanced ETL scenarios using Informatica. You will be introduced to the concepts - Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint Based Loading, Target Load Order Group, CDC (Change Data Capture) etc. We will also discuss creating Data Warehouses related processes like SCD, Fact and Dimension Loading.
Topics:
- Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
- Advanced techniques - Flat File, XML File
- Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
Hands-On/Demo:
- Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
- Advanced techniques - Flat File, XML File
- Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)