ETL Testing online training


MSR Trainings: is a brand and providing quality ETL Testing Online Training  with experiance faculty with online support for students and employees in world wide.

Highlights in our training service:

Every faculty has Real Time experiance .Trained Resources placed in countries like Australia, USA, UK, JAPAN, SWEDEN etc.Any critical issues faced by resource resolved using Teamviewer, webex.Supporting the resource with Top 100 Interview questions.Resume built in best corporate standards according to the job description.We will market the resume for top technolgy countries.After each week a status exam is conducted.offline online trainings are conducted everyday.Weekend trainings for job goers.flexible timings in accordance with the resource comfortability.If version related to any Tool is upgraded. We will send the upgraded information via email.we will develop the Aquintance with Production,development and testing environments.Real time scenarios covered accross Software Development Life Cycle.for every 10 hours One hour catered to resolve the doubts.Explaining bugs and critical issues and development activities 24*7 technical supports sevices.

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)
*  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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s