India : +91 996 395 7366


ETL TESTING Online Training

DataWare Housing Concepts:
  •   What is Data Ware House?
  •   Difference between OLTP and DataWare Housing
Data Acquisition
  •   Data Extraction
  •   Data Transformation
  •   Data Loading
Data Marts
  •   Dependent Data Mart
  •   Independent Data Mart
Data Base Design
  •   Star Schema
  •   Snow Flake Schema
  •   Fact constellation Schema
SCD(slowly changing dimension)
  •   Type-1 SCD
  •   Type-2 SCD
  •   Type-3 SCD
Basic Concepts in SQL
  • Overview of ETL Tool Architecture
  • White Box and Black BOX Testing Functionality on Different Transformation Rules
Data Ware House Life Cycle
Different Types of Testing Techniques in ETL
  •   Minus Queing
  •   Count  Queing
ETL Testing Concepts
  •    What is use of testing
  •    What is quality & standards
  •    Responsibilities of a ETL Tester
2.Software development life cycle
  •    Waterfall model
  •    V-model
  •    Agile model & methodology
  •    Prototype model
  •    Spiral model
3.Testing methodologies
  •    White box testing
  •    Black box testing
  •    Grey box testing
  •    ETL Testing Work Flow Process
  •    How to Prepare the  ETL Test Plan
  •    How to design the Test cases in ETL Testing.
  •    How to reporting the Bugs in ETL Testing ?
  •    ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
  •    How to detect the bugs through database queries
  •    ETL Performing Testing & Performing Tuning