ETL Testing Online Training

 

ETL and Report Testing Course Details

What is Data Warehousing?

Differences between OLTP and Data Warehousing

 

DATA ACQUISITION

• DATA EXTRACTION
• DATA TRANSFORMATION
• DATA LOADING

 

Data Marts

• Dependent DM
• Independent DM

 

Data Warehousing Life Cycle
Database Design

 

• Star Schema
• Snowflake Schema
• Fact Constellation Schema

 

SCD (Slowly changing Dimensions)

• TYPE1 SCD
• TYPE2 SCD
• TYPE3 SCD

 

Basic concepts in SQL
Overview of ETL Tool Architecture
Components in ETL Tool
Coding and Testing process in different transformation rules:

 

• SAMPLE Loading from source to target
• SORTER Transformation
• FILTER Transformation
• ROUTER Transformation
• EXPRESSION Transformation
• JOINER Transformation
• UNION Transformation
• AGGREAGATOR Transformation
• RANK Transformation
• STORED PROCEDURE Transformation
• SEQUENCE GENERATOR Transformation
• Flat File
• SQL Transformation

 

Different types of testing techniques in ETL 
MINUS Query
COUNT Query

• SAP
• Microsoft Technologies
• Oracle Apps
• Testing tools
• Peoplesoft
• Data Warehouse
• Network/System Administration
• Databases
• Middleware Technologies
• Other Technologies