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