Informatica PowerCenter 9.6

S.No Session Contents Session App. Time

Data Warehouse Intro and

Architectures

OLAP and OLTP

Schemas – Star Schema &

Data Ware housing Snow Flake Schema

1 1.5

Concepts Business Intelligence overview

Data Mining – Overview ; Data

Mining Vs Data Warehouse

Powercenter Architecture

Key Components: Mappings,

transformations, sessions,

workflows and workflow

Monitor

Informatica Domain, Powercenter

2 1.5

Overview Repository,

Administrator,Client

Repository Service, Integration

Services

Create Users & Groups

Establish Source and target con

Working with sources - CSV,COB

Working withTargets - Creating

Powercenter Mapping - Overview

3 2

Components Mapplets and Mapplets - Overv

User Defined Functions

Mapping Parameters and Variab

Transformations Overview

Developing Transformation

Reusable transformations - Trac

Active vs. Passive Transformatio

Source Qualifier

4 Transformations - I 2

Transformation

Aggregator Transformation

Reusable/Non Reusable Aggreg

Expression Transformation

Filter Transformation

Joiner Transformation -

Advanced Properties

Rules and Guidelines for Joiner

transformation:

Sorted Input - Master Detail

5 Transformations - II Rank Transformation 2

 

Router Transformation

Sorter Transformation

UnionTransformation

Debugger in Informatica

Defining Break points

Lookup transformation - Conne

Unconnected Lookups

Lookup Cache

Dynamic Lookups

6 Transforamtions - III 3

Multiple Row Return Lookup

Sequence Generator transforma

Normalizer transformation

Update Strategy transformation

Java Transformation

SQL Transformation

Web Service consumer transfor

Transforamtions -

7 XML Source and Targets 2

IV

XML Transformation - XML

Source

Qualifier/Parser/Generator

Identifying BottleNecks

Optimize Target

Performance

8 Optimize Source - Mappings - 2

Tuning

Transformations

Optimizing Sessions

SCD Type 1

SCD Type 2

Slowly Changing

9 SCD Type 3 3

Dimension

Slowly Growing Target

Mapping

Workflows & worklets -

Overview

Versioned Repositorty - Check

Workflow Basics in & Check out

Sessions Overview & Tasks

10 Optimizing Sessions - Pre & 3

Post Session Commands

Using a File List

Configuring Sources & Targets

session

Link Conditions

Tasks Overview

Assisgnment Task

Command Task

11 Workflow Tasks 2

Event Task

Timer Task