Wednesday 13 August 2014

online etl training in hyderabad

Course Name : ETL TESTING                                                   24*7 technical 

support
Faculty : Real time experience     
              Rs Training's is a brand and providing quality online and offline training's to students in world wide.We are providing etl testing online training with real time scenarios

Highlights in our training service:
                            Every faculty has Real Time experience .Trained Resources placed in countries like Australia, USA, UK, JAPAN, SWEDEN etc.Any critical issues faced by resource resolved using Team viewer, web ex. 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 technology countries.After each week a status exam is conducted.offline online training's are conducted everyday.Weekend training's for job goers.flexible timings in accordance with the resource comfort ability. If.If version related to any Tool is upgraded. We will send the upgraded information via email.we will develop the Acquaintance with Production,development and testing environments.Real time scenarios covered across 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 services.

 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
    *  AGGREGATION Transformation
    *  RANK Transformation
    *  STORED PROCEDURE Transformation
    *  SEQUENCE GENERATOR Transformation
    *  Flat File
    *  SQL Transformation
•  Data warehousing Life Cycle
•  Different Types of testing 
  Techniques in ETL
    *  MINUS Query
    *  COUNT Query

No comments:

Post a Comment