Informatica 9 With Case Study Online Training From Vastly Exp Mentor

[D2trainings]

The call is for people who are not looking to get into programming jobs, learn Informatica 9 and venture into Data Warehouse. Our mentor is vastly experienced and is located in USA and has loads of experience in diversified industries. Our training's are interactive,always keeping the students on the edge, which will create an healthy learning experience with timely assignments. Please go through the course content which is mentioned below.

 

COURSE CONTENTS FOR INFORMATICA 9 WITH CASE STUDY 

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

Transformations Contd 
- Multiple Targets Loading
- Router Transformation
- Diff Between Filter and Router Transformations
- Create a Mapping
- Master Outer Join

Transformations Contd 
- Create a Mapping
- Reusable Transformation
- Lookup Transformation
- Debugger
- Handling Multiple Files as Source

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

Transformations Contd 
- Create a Mapping
- Lookup Transformation - Persistent Cache
- Aggregator Transformation
- Sorter Transformation
- Creating Stored Procedure

 

Transformations Contd 
- Normalizer Transformation
- Stored Procedure Transformation
- Active Vs Passive Transformations
- Connected Vs UnConnected Transformations

 

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
- Removing Duplicate Rows

- Export and Import  on Objects

- Performance tuning

- Partitioning

- Understanding Jobs and Scheduler

- Pmcmd

- Overview of UNIX scripting

 

 

For further details:

Joseph

PH: 609-365-7993

E: [email protected]