ETL Training
By
MGTechnosoft

Data-ware Housing & ETL (Informatica) Concepts      

1.Database Design      

• Normalization    
• De-Normalization    
• Examples        

2.Data-warehouse Introduction            

• Define Data-warehouse    
• Data Warehouse Architecture    
• The Top-Down Approach    
• The Bottom-up Approach    

Differences between OLAP & OLTP   

OLAP     

• OLAP Architecture     
• OLAP Servers          
• R OLAP Server          
• M OLAP Server          
• H OLAP Server     
• OLAP Operations           
• Roll up Operation          
• Drill down Operation          
• Slice Operation          
• Dice Operation          
• Pivot Operation   

 Types of Data Warehouse          

• Enterprise Data Warehouse          
• Data Marts                   
• Dependent Data Mart                   
• In-dependent Data Mart          
• ODS (Operational Data Store)       

 3Data Models      

• Conceptual Data Model    
• Logical Data Model    
• Physical Data Model    
• Comparisons of CDM, LDM & PDM    
• Pictorial Representation of these models        

4Dimensional Modelling      

• Dimension & Facts    
• Attributes, Hirearchy    
• Star Schema Architeture    
• Snow-Flake Schema    
• Pictorial Representation of Star & Snow Flake schemas    
• Types of Dimensions    
• Types of Facts    
• Types of Fact Tables    
• Slowly Changing Dimensions [SCD] & their types        

5Data Acquisition      

• Define Data Acquisition [ETL]    
• Steps in ETL    
• ETL Architecture    
• ETL tools    
• Sources v/s Targets    
• Define a Transformation        

6.Transformations

• Active v/s Passive Transformation    
• Connected v/s Un-connected Transformation    
• Introduction to following types of Transformation    
• Source Qualifier Transformation   
• Aggregate Transformation   
• Sorter Transformation   
• Filter Transformation   
• Expression Transformation    
• Union Transformation    
• Router Transformation    
• Rank Transformation    
• Sequence Generator Transformation   
• Lookup connected Transformation    
• Lookup Un-connected Transformation    
• Stored Procedure connected Transformation   
• Stored Procedure Un-connected Transformation   
• Normalizer Transformation    
• Update Strategy Transformation   
• Reusable Transformation    
• Mapplet (Group of Transformation)    
• Mapplet Input Transformation    
• Mapplet Output Transformation   
• XML Source Qulifier Transformation   
• XML Source  
• XML Target                              

Advance ETL Concepts        

• Task Developer        
• Worklet Designer        
• Session Task        
• Session Partioning        
• Session Properties        
• Email Task (Pre/Post(Success/Failure))        
• Command Task (Pre/Post(Success/Failure))        
• Event Task        
• Target Load Plan        
• Constraint Based Loading        
• Workflow Scheduler        
• Indirect File Loading        
• Parameters/Variables (Mapping/Mapplet/Workflow/Worklet)      

Interview & Resume Preparation