ETL and Report Testing Course Content

What is Data Warehousing?

Differences between OLTP and Data Warehousing

DATA ACQUISITION
• What are the different phases of SDLC?
• 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