DATA WAREHOUSE CONCEPTS
Introduction

– Need of Data Warehouse
– Characteristics of OLTP and OLAP

Architecture of Data Warehouse
– Definition of Data Warehouse
– Dimension and Fact Tables
– Star Schema
– Snow Flake Schema

– Importance of Staging Area
– Surrogate Keys
Slowly Changing Dimensions (SCD)
– SCD Type 1
– SCD Type 2
– SCD Type 3

Types of Dimensions and Fact Tables
– Time Dimension
– Types of Facts — Additive, Semi Additive, Non Additive
– Factless Fact Table

INFORMATICA 9 WITH CASE STUDY

Introduction and Architecture
-Introduction to Informatica
– Architecture of Informatica — PowerCenter 9
– Informatica Design Process
– Informatica Client Tool — Designer
– Source Analyzer and Warehouse Designer

Mapping Designer
– Create a Simple Mapping
– Overview of Transformations
– Types of Transformations — Active and Passive
– Expression Transformation
– Source Qualifier Transformation
– Introduction to Workflow Manager
– Task Developer
– Workflow Designer
– Creating Connections

Flat Files Handling
– Create Simple Mappings
– Flat File Analysis

Architecture Review
– Architecture 9 Review
– Command Task
– Create a Mapping
– Joiner Transformation

Transformations
– Create a Mapping
– Using Join in a Source Qualifier Transformation
– Expression Transformation
– Filter Transformation
– Multiple Targets Loading
– Router Transformation
– Diff Between Filter and Router Transformations
– Create a Mapping
– Master Outer Join

– Create a Mapping
– Reusable Transformation
– Lookup Transformation
– Debugger
– Handling Multiple Files as Source

– Lookup Transformation – Persistent Cache
– Aggregator Transformation
– Sorter Transformation
– Creating Stored Procedure

– Normalizer Transformation
– Stored Procedure Transformation
– Active Vs Passive Transformations
– Connected Vs UnConnected Transformations

Update Strategy
– SCD Type 1 mapping Implementation
– Update Strategy Transformation
SCD Type 2
– SCD Type 2 mapping Implementation

Loading Strategy
– Sequential and Parallel Loading
– Union Transformation
– Dynamic Lookup Cache
– Introduction to Fact Loading
– Create a Mapping

Mapplets
– Create Mappings
– Sequence Generator Transformation
– Multiple Pipelines in a Single Mapping
– Target Load Plan
– Mapplets

Implementing Incremental Loading
– Create a Mapping
– Importance of Mapping Variable

Implementing Incremental Aggregation
– Create a Mapping
– Incremental Aggregation

Transaction and Variable Port
– Transaction Control Transformation
– Variable Ports

Workflow Tasks
– Scheduling
– Task Link Properties
– Event Raise Task
– Event Wait Task
– Worklet

Advance Features in Informatica
– Parameter Files
– Export and Import on Objects

– Performance tuning

– Partitioning

– Understanding Jobs and Scheduler

– Pmcmd

– Overview of UNIX scripting

ETL Testing

  • STLC

– Bug Life Cycle

– How many steps ETL Contains ? Explain with Eg. Valid data(BCOE),Structure

Validation, Count Validation, Data Validation, Report Validaion, Data Validation and

Verification

– Severity and Priority

About Our Expert Trainer

Mr.Sobhan has an extentive Data Warehouse and informatica experience of more than 15 Years with companies like IBM, ORACLE inc,Fidelity Investment,etc in past. My current engagement is a Data Architect where I am responsible for designing the Data Warehouse and ETL FLow. He also has more than 6 years of Informatica Training experiance in both classroom and Online Mode.