Informatica PowerCenter




Course Description

Informatica has several products focused on data integration. However, Informatica PowerCenter is the flagship product in the portfolio. It has become so popular that Informatica PowerCenter has now become synonymous to Informatica. So whenever I use Informatica in the blog now, it essentially means Informatica PowerCenter. Informatica is a data integration tool based on ETL architecture. It provides data integration software and services for various businesses, industries and government organizations including telecommunication, health care, financial and insurance services.

Course Content


Introduction to Dataware Housing

Data warehouse concept

Differences between Online Transaction Processing and data warehouse

Types of Data Warehouse

Data warehouse Architecture

Difference between Data warehouse & Data mart

Data Warehouse Approaches

Data Warehouse Components

Logical & physical Design

Operational data sources(ODS)


Fact Table

Dimension tables and types

Data Warehouse Schemas: Star schema and

Star Query, star flake schema, snow flake

schema and Galaxy Schema

Informatica PowerCenter

Product Overview

PowerCenter Domain

Administration Console

PowerCenter Repository

PowerCenter Client

Repository Service

Integration Service


Adding a Repository to the Navigator

Configuring a Domain Connection

Connecting to a Repository

Viewing Object Dependencies

Validating Multiple Objects

Comparing Repository Objects

Working with FoldersAgenda(Continue..)


Source Analyzer

Working with Relational Sources

Working with Flat Files

Target Designer



Working with Ports

Using Default Values for Ports

User-Defined Default Values

Tracing Levels

Basic First Mapping

Expression Transformation

Filter Transformation

Router Transformation

Union Transformation

Sorter Transformation

Rank Transformation

Aggregator Transformation

Joiner Transformation

Source Qualifier

Lookup Transformation

Lookup Types

Lookup Transformation Components

Connected Lookup Transformation

Unconnected Lookup Transformation

Lookup Cache Types: Dynamic, Static, Persistent, Shared

Update Strategy

Dynamic Lookup Cache Use

Lookup Query

Lookup and Update Strategy Examples

Stored Procedure Transformation

Connected Stored Procedure Transformation

Unconnected Stored Procedure Transformation

Sequence Generator Transformation

SCD Type 1 and Type 2 with real time examples

Mapplets: Mapplet Input and Mapplet Output Transformations

Normalizer Transformation

XML Sources Import and usage

Mapping Parameters and Variables

Parameter File

Indirect Flat File Loading


Working with Workflows

Assigning an Integration Service

Working with Links

Workflow Variables

Session Parameters

Working with Tasks

Session Task

Command Task

Working with Event Tasks

Email task

Decision Task

Control Task

Timer task

Assignment Task

Session Properties

Workflow Properties


Push down Optimization Technique

Version Control

Constraint Based Load Ordering

Target Load Plan Order