ETL Testing Training

•  What is Data Warehousing?

•  Difference between OLTP and Data Warehousing

•  Data Acquisition

    *  Data Extraction
    *  Data Transformation
    *  Data Loading

•  Data Marts

    *  Dependent DM
    *  Independent DM Database Design
    *  Star Schema
    *  Fact Constellation Schema SCD (Slowly Changing Dimensions)
    *  TYPE1SCD
    *  TYPE2SCD
    *  TYPE3SCD Basic concepts in SQL.

•  Overview of ETL Tool Architecture

•  Components in ETL Tool

-->White Box and Block Box testing
-->functionality in different

Transformation rules:

    *  SAMPLE Loading from source target
    *  SORTER Transformation
    *  FILTER Transformation
    *  ROUTER Transformation
    *  EXPRESSION Transformation
    *  JOINER Transformation
    *  UNION Transformation
    *  AGGREGATOR Transformation
    *  RANK Transformation
    *  STORED PROCEEDURE Transformation
    *  SEQUENCE GENERATOR Transformation
    *  Flat File
    *  SQL Transformation

•  Data warehousing Life Cycle

•  Different Types of testing

  Techniques in ETL

    *  MINUS Query
    *  COUNT Query