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