V9 Staffing

Request a Call Back

ETL Testing Online Training

Home ETL Testing Online Training

ETL Testing Online Training

Complete ETL & Report Testing curriculum covering data warehousing fundamentals, ETL processes, dimensional modeling, SQL basics, transformation rules, and ETL testing techniques.

ETL & Report Testing Course Details

What is Data Warehousing?
Differences between OLTP and Data Warehousing

Data Acquisition

Data Acquisition
Data Extraction
Data Transformation
Data Loading

Data Marts

Dependent DM
Independent DM

Data Warehousing Life Cycle & Database Design

Data Warehousing Life Cycle
Database Design

Dimensional Modeling

Star Schema
Snowflake Schema
Fact Constellation Schema

SCD (Slowly Changing Dimensions)

Type 1 SCD
Type 2 SCD
Type 3 SCD

SQL & ETL Tool Concepts

Basic concepts in SQL
Overview of ETL Tool Architecture
Components in ETL Tool

Coding & Testing - Transformation Rules

Sample Loading from source to target
Sorter Transformation
Filter Transformation
Router Transformation
Expression Transformation
Joiner Transformation
Union Transformation
Aggregator Transformation
Rank Transformation
Stored Procedure Transformation
Sequence Generator Transformation
Flat File
SQL Transformation

ETL Testing Techniques

Different types of testing techniques in ETL
MINUS Query
COUNT Query