DATA WAREHOUSING & ETL 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