Session : 1 – Data Warehouse Introduction

Session : 2 – Power Center Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console

Session : 3 – Informatica Concepts and Overview

  • Informatica Architecture.

Sources

  • Working with relational Sources
  • Working with Flat Files

Session : 4 – Targets

  • Working with Relational Targets
  • Working with Flat file Targets

Session : 5 – 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

Session : 6 – Workflow Manger

  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
  • Session
  • Decision task
  • Control Task
  • Event wait task
  • Timer task
  • Monitoring workflows and debugging errors

Session : 7 – Indirect Loading

Session : 8 – Constraint based load ordering

Session : 9 – Target Load plan

Session : 10 – Worklet ,Mapplet ,Resuable transformation

Session : 11 – Migration –XML migration and Folder Copy.

Session : 12 – Scheduling Workflow

Session : 13 – Parameter and variables

Session : 14 – XML Source, Target and Transformations

Session : 15 – Performance Tuning

  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya