Successfully provided training on Data Warehouse Concepts, 
Informatica and Business Objects from July 2004. 1200 + Students 
got trained from us as part of the class room Training. Started 
Online training from Oct 2007 and trained about 200 + Students. 

FOR DEMO VISIT www.sanzatechnologies.com/demo.wmv 

CONTACT = HEMA  972-999-9183 

PST TIMINGS 

BATCH STARTS ON 15TH DECEMBER 2008  7.30 PM PST ON INFORMATICA 
8.1.1, FIRST 2 DAYS CLASS FREE 

EST/CST TIMINGS 

BATCH STARTS ON 15TH DECEMBER 2008  7.30 PM EST ON INFORMATICA 
8.1.1, FIRST 2 DAYS CLASS FREE 


COURSE CONTENTS FOR INFORMATICA 8.1.1 WITH CASE STUDY 

CHAPTER WISE AGENDA 

DATA WAREHOUSE CONCEPTS 

Chapter 1 - Introduction 

- Need of Data Warehouse 
- Purpose of Analysis 
- Evolution of Reporting 
- Data -- Information - Knowledge 
- Importance of Transaction Systems -- OLTP 
- Characteristics of OLTP 

Chapter 2 - Architecture of Data Warehouse 

- Definition of Data Warehouse 
- Architecture of Data Warehouse 
- Goals of Data Warehouse 
- Characteristics of Data Warehouse 
- Differences -- OLTP / DW 
- Dimensional Modeling 
- Dimension and Fact Tables 
- Size of Fact Table 
- Star Schema 
- Snow Flake Schema 
- Surrogate Keys 
- Grain Level 

Chapter 3 - Implementation Methodology 

- Data Mart 
- Difference between Data Mart and Data Warehouse 
- Inmon Methodology 
- Kimball Methodology 
- Importance of Staging Area 

Chapter 4 - Slowly Changing Dimensions (SCD) 
- SCD Type 1 
- SCD Type 2 
- SCD Type 3 

Chapter 5 - Types of Dimensions and Fact Tables 
- Conformed Dimension 
- Degenerated Dimension 
- Time Dimension 
- Types of Facts -- Additive, Semi Additive, Non Additive 
- Factless Fact Table 

Chapter 6 - Environment 
- Development / Test / Production Environment 
- Implementation Methodology 

Chapter 7 - Data Loading 
- Load Window 
- Initial Load 
- Incremental Loading 

Chapter 8 - Meta Data Management 
- Metadata 

INFORMATICA 8.1.1 WITH CASE STUDY 

Chapter 1 -- Introduction and Architecture 

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

Chapter 2 - 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 

Chapter 3 -- Flat Files Handling 
- Create Simple Mappings 
- Flat File Analysis 

Chapter 4 -- Architecture Review 
- Architecture 8.1 Review 
- Differences between PowerMart and PowerCenter 
- Connecting to SAP 
- FTP Process 
- Command Task 
- Create a Mapping 
- Joiner Transformation 

Chapter 5 -- Transformations 
- Create a Mapping 
- Using Join in a Source Qualifier Transformation 
- Expression Transformation 
- Filter Transformation 


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

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

Chapter 8 -- Mapplets 
- Create Mappings 
- Sequence Generator Transformation 
- Multiple Pipelines in a Single Mapping 
- Target Load Plan 
- Mapplets 

Chapter 9 -- Update Strategy 
- SCD Type 1 mapping Implementation 
- Update Strategy Transformation 


Chapter 10 -- SCD Type 2 
- SCD Type 2 mapping Implementation 

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

Chapter 12 -- Transformations Contd 
- Create a Mapping 
- Date Dimension Loading 
- Lookup Transformation - Persistent Cache 
- Aggregator Transformation 
- Sorter Transformation 
- Creating Stored Procedure 

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

Chapter 14 -- Implementing Incremental Loading 
- Create a Mapping 
- Importance of Mapping Variable 

Chapter 15 -- Implementing Incremental Aggregation 
- Create a Mapping 
- Incremental Aggregation 

Chapter 16 -- Transaction and Variable Port 
- Transaction Control Transformation 
- Variable Ports 

Chapter 17 -- Workflow Tasks 
- Scheduling 
- Task Link Properties 
- Event Raise Task 
- Event Wait Task 
- Worklet 

Chapter 18 -- Others 
- Parameter Files 
- Removing Duplicate Rows