Informatica Training in Chennai

Best Informatica Training institute in Chennai

Informatica Training Syllabus

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 Qualifer
  • 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

Call us today and see how
you can give a new life to your career.

Contact Now