ETL TESTING Training

FACULTY: Real-time experience 24×7 technical support

SIGNEXIT SYSTEMS is a brand and providing quality Online and Offline trainings to students in world wide. We are providing very best Online training on ETL Testing

COURSE CONTENT:

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

Our Online Services providing worldwide like Asia, Europe, America, Africa, Sweden,North Korea, South Korea, Canada,Netherland,Italy, Russia,Israel,New Zealand ,Norway,Singapore,Malasia,etc,,