IT Online Training and Placements in USA.

Testing Tools Online Training

QA, QTP, Load Runner, ETL Testing.

 

Courses » Testing Tools » ETL Testing Online Training

 

ETL Testing 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