Syllabus of Informatica Course in Chennai
Data Warehouse Introduction
Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power Center Admin Console
Informatica Concepts and Overview
- Informatica Architecture.
Sources
- Working with relational Sources
- Working with Flat Files
Targets
- Working with Relational Targets
- Working with Flat file Targets
Transformations – Active and Passive Transformations
- Expression
- Lookup –Different types of lookup Caches
- Sequence Generator
- Filter
- Joiner
- Sorter
- Rank
- Router
- Aggregator
- Source Qualifier
- Update Strategy
- Normalizer
- Union
- Stored Procedure
- Slowly Changing Dimension
- SCD Type1
- SCD Type2 — Date, Flag, and Version
- SCD Type3
Workflow Manager
- Creating Reusable tasks
- Workflows, Worklets & Sessions
- Tasks
- Session
- Decision task
- Control Task
- Event wait task
- Timer task
- Monitoring workflows and debugging errors
Indirect Loading
Constraint-based load ordering
Target Load plan
Worklet, Mapplet, Reusable transformation
Migration –XML migration and Folder Copy.
Scheduling Workflow
Parameter and variables
XML Source, Target, and Transformations
Performance Tuning
- Pipeline Partition
- Dynamic Partition
- Pushdown optimization
We have weekly demo classes for Informatica, do feel free to give us a call and drop in.
