TrainersGlobe - ETL Testing Trainings, Certification, Interview, Job Support
ETL Testing Training Course
Prism IT Corp 2017 H1B Sponsorship
  • Demos
  • Job Trend / Job Market for ETL Testing
  • Direct Client Requirements for ETL Testing
  • ETL Testing Course Content
    • Note : We Provide Customized Course Content Based On Your Requirement.

      •  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