For Online Training Aspirants (With Placement)

Name :

Email :

Phone :

Message :


Courses

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

 

FAQ
© Copyright 2013 Tectist., All rights reserved