- Introduction to Data Warehousing
- Introduction to OLTP
- ETL and OLAP Systems
- Dimensional Modelling
- Types of Schema’s
- Types of Fact and Dimension Tables
- Why do we Need ETL tools
- What is Informatica?
Power Centre Components
- Informatica Architecture
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
Informatica Concepts and Overview
- Source Qualifier
- Target Designer
- Transformations
- Mappings & Mapplets
- Sessions
- Workflows & Work lets
- Tasks
Sources
- Working with Relational Sources
- Working with Flat Files (Direct/Indirect)
Targets
- Working with Relational Targets
- Working with Flat file Targets
Transformations
- Active and Passive Transformations
- Connected and Unconnected Transformations
- Reusable,
- Non Reusable & Shortcuts
- Expression
- Source Qualifier
- Filter
- Joiner
- Sorter
- Rank
- Router
- Union
- Aggregator
- Sequence Generator
- Lookup
- Stored Procedure
- Update Strategy
- Normaliser
- SQL Transformation
- Transaction Control
- Mapplet input and Output transformation
Implementation of Slowly Changing Dimensions
Cache concepts (Lookup, Aggregator, Joiner, Sorter)
- Tasks
- Start
- Session
- Assignment
- Event raise and Event wait
- Email
- Command
- Decision
- Timer
- Control
Advanced features
- Incremental Aggregation
- Mapplet Implementation
- Target Load Plan
- Target update override
- Constraint Based loading
- Mapping Parameters & Variables
- Session Parameters
- Link Conditions
- Performance Tuning
Real Time scenarios & FAQ’s
