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