Introduction to Data Warehousing Concepts.

Ø  What is Data warehousing?

Ø  Who needs Data warehouse?


Ø  Why Data warehouse is required?

Ø  Components of a Data warehouse & Architecture

Ø  Data Cleansing

Ø  ODS (Operational Data Store)

Ø  Understand Dimensions, Fact tables

Ø  What is Confirmed Dimension, Factless Fact Table

Ø  Understand Datwarehouse Schema- Star Schema, Snowflake Schema, Galaxy Schema.


Introduction to ETL

Ø  Components of ETL

Ø  Various ETL tools available in Market

Power Center 9.0.1 Architecture and Components:

Ø  Introduction to Informatica Power Center (Data Integration)

Ø  Power Center 9.x Architecture

Ø  Components of Power Center:

Ø  Power Center Server Components: Integration Server, Repository Server.

Ø  Power Center Client tools: Repository Manager, Designer, Workflow manager, Workflow Monitor.

Overview of Informatica PowerCenter Installation

Ø  System Requirements

Ø  Database Installation and schema creation

Ø  Creating Domains and Configurations

Ø  Creating DB User for Repository

Ø  Create a Repository and Integration Service

Ø  Creating users and folders

Informatica Power Center Web Administrator Console

Ø  Creating the Repository Server

Ø  Configuring Repository Server

Ø  Creating Integration Services

Informatica PowerCenter Repository Manager

Ø  Adding Repository

Ø  Creating the Workspace (Folder)

Ø  Giving privileges to the users, user groups and folders

Informatica Power Center Designer

Ø  Introduction to designer

Ø  Designer Interfaces

Ø  Designer tools

Ø  Connecting to Designer

Ø  Components of Designer

Ø  Creating Data Source Names (ODBCs)

Ø  Accessing the source, destinations to the designer

Ø  Defining Sources using  ‘Source Analyzer’.

Ø  Database as a source

Ø  Flat Files sources

Ø  Defining Targets using ‘Target Designer’

Ø  Working with Relational Targets

Ø  Working with Flat File Targets

Ø  Creating target database objects

Ø  ‘Mapping designer’

Ø  Mapping between the source and target tables

Ø  Transformation between source and target tables


Informatica PowerCenter Designer – Understand Transformations

Ø  What are “Informatica Transformations”

Ø  Active and Passive Transformations

Ø  Connected and Unconnected Transformations

Informatica Transformations:

1)     Filter Transformation

2)     Router Transformation

3)     Expression Transformation

4)     Source Qualifier Transformation

5)     Joiner Transformation

6)     Sorter Transformation

7)     Aggregator Transformation

8)     Rank Transformation

9)     Stored Procedure Transformation

10)  Lookup Transformation:

Connected and Unconnected Lookup

11)  Lookup Caches:





12)  Sequence Generator Transformation

13)  Update Strategy Transformation

Informatica PowerCenter Reusable Components

Ø  Creating Reusable Transformations using ‘Transformation Developer’

Ø  Creating Mapplets using ‘Mapplet Designer’

Ø  Creating Reusable Session tasks using ‘Task Developer’

Ø  Creating Worklets using ‘Worklet Designer’


Informatica PowerCenter Workflow Manager

Ø  Define Informatica Workflow and why do we need them

Ø  How to create a Workflow using ‘Workflow Manager’

Ø  Components of a Workflow

Ø  Defining Tasks in Workflow

Ø  Create a Command Task

Ø  Configure Event Wait 

Ø  Create a Email Task

Ø  Create a Session Task and understand different settings

Ø  Creating Relational Connections

Ø  Start Workflow

Ø  Monitor Workflow

Ø  Understand Session logs

Ø  Understand Workflow Logs

Slowly Changing Dimensions (SCDs):

SCD concept (Slowly Changing Dimensions)

Ø  Understand the Flow of Type-I mappings

Ø  Understand the Flow of Type-II mappings

Ø  Understand Type-III mappings

Informatica PowerCenter Advanced Topics:

Debugging Mappings

How to Debug Mapping using Designer tool

Understand Mapping Parameters (Parameter File)

How to use Mapping Parameters

Workflow Scheduling: Scheduling Tools

Ø  Use Informatica Scheduler

Ø  Use 3rd party scheduling tools like DAC.

Target Load Plan

Understand running of multiple pipelines in a mapping using an Order or load

Incremental Aggregation

Explore incremental aggregation to apply captured changes in the source data (CDC part) to aggregate calculations in a session.

Understand Various Session level Properties Available.