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