ETL Details

  • Faculty Not Specified
  • 120 Mins/Day
  • 45 Days

  • 8:00 AM-8:00 PM
  • Not Provided
  • Online / Classroom Training





ETL Course Details

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                                     

ETL Course Content

Course Content not provided...

About MGTechnosoft

Institute Address
MGTechnosoft

#33/1, K N N Complex, 3rd Floor, 10th Main Road, Gokula 1st Stage, 2nd Phage, HMT Main Road, Mathikere (Yeswanthpur), Bangalore-560054 Land Mark :- Near to the Ramaiya college Bus Stop, Above to the South Indian Bank & Beside to the New Agrawal Bhavan.,

Send Course Enquiry

Related Courses

Related Ads