Knowledge for great careers





ETL ONLINE TRAINING

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.