Introduction To Data Warehousing
Introduction To ETL And Reporting
What Is Fact And Dimensions?
Power Center Components Designer Workflow Manager Workflow Monitor Repository Manager
Informatica Overview Informatica Components Informatica Architecture
Informatica Sources And Targets Flat Files Database
Transformation What are the main transformations used? Active and passive transformations Reusable transformations
Workflow Manager
Flat File – Indirect Loading
Target Load Order
Worklet And Mapplet
Setting Dependency Between Tasks
Parameter And Variables
Scheduling Workflow
Concurrent Workflows
Pre Session Commands And Post Session Commands
Monitoring And Error Fixing
Performance Tuning
Administration Activities