Informatica Training Syllabus

Introduction Of Data Warehouse

• What Is Data Warehouse?
• Data Warehouse Architecture
• Explain OLTP, OLAP
• Explain Schemas

First Steps

• What Is Etl?
• What Is Informatica?
• Informatica Architecture Overview
• Installation of the Product in Windows and using Oracle as Database
• Explain Informatica Power Center Components
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console

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 Qualifer
• Update Strategy
• Normalizer
• Union
• Stored Procedure
• Slowly Changing Dimension
  • SCD Type1
  • SCD Type2 — Date, Flag and Version
  • SCD Type3

Workflow Manger

• 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 ,Resuable 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