Informatica Training

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 Cache

Sequence Gener

 Filter

Joiner

 Sorter

Rank

Route

  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& Sessio

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