Data Integration with Informatica PowerCenter
Syllabus
 

Professional training from beginner to expert for Data Integration skills with Informatica PowerCenter.

​

​Data warehouse Fundamentals

​

1. Data Warehouse fundamentals, Principles and Approaches related to Business

2. Data Warehouse Architecture with examples from real designs.

3. Translation of Requirements from High to low Level

4. Understanding roles and responsibilities as part of architecture

5. Dimensional Modelling Principles and Schemas

6. SCDs, Metrics and fact types and examples

​

Power Center Server Components 

​

1. Significance of Informatica (Power Center Tool) and its Architecture

2. Overview of Admin roles and responsibility

3. Informatica Server components

​

PowerCenter client component - Designer 

​​

1. Technical design specifications for Simple to Complex Mappings

2. PowerCenter Repository Manager Designer, Workflow Manager & Monitor and their components

3. Source Target components and transformation and its classification

4. Building sessions and task execution with connections

5. Designing Tasks with Transformations for different business scenarios

6. Session logs, debugging and data tracking 

7. Optimising transformation for performance, source, target and mapping tuning

8. Introduction to Master Data Management

9. Optimising performance, partitions and pushdown optimisation

10. Implementing Change Data Capture

11. Mapping parameters and variables

12. Reusable tasks, Mapplets and shortcuts

13. Static, Dynamic lookups and Cache

14. Mapplets, reusable transformations and shortcuts

15. Implementation of  Slowly changing dimension types per business 

​​

​

Project and Mock Interviews