Informatica

1. Introduction
2. Architecture of Informatica
3. Informatica Power Center Components
4. Power Center Client
5. Power Center Designer and Work flows  
6. Create basic mapping and workflow for Table
7. Create basic mapping from Flat file to DB Table  
8. Type of tasks in Informatica
9. Data Transformation Manager (DTM)

Transformations

1. Transformations
2. Source Qualifier Transformation
3. Tracing Level in Informatica
4. Filter Transformation
5. Router Transformation
6. Expression Transformation
7. Sorter Transformation
8. Aggregator Transformation
9. Sequence Generator
10. Rank Transformation
11. Joiner Transformation
12. Lookup Transformation
13. Lookup Properties
14. Create and Implement Lookup Transformation
15. Create and Implement Un-connected Lookup Transformation
16. Union Transformation
17. Update Strategy Transformation
18. Java Transformation
19. SQL Transformation
20. Normalizer Transformation
21. Transaction Control Transformation
22. Stored procedure Transformation

Slowly Changing Dimensions(SCD)

1. SCD1
2. SCD2
3. SCD3

Advanced Concepts

1. Reusability in Informatica
2. Mapplets
3. Version Control
4. Parameters and Variables 
5. Target Load Plan/Target Load Order
6. PMCMD Command
7. Partitioning in Informtica
8. Pushdown Optimization
9. Bottlenecks in Informatica
10. Constraint Based Loading
11. Informatica Scheduler