Selenium Online training

ETL Testing

ETL Testing online training or ETL Testing online course by United Trainings. ETL testing is the process where you extract data from Source Tables, transform them in to the desired format based on certain rules and finally load them onto Target tables.

 

 

Course Content – ETL Testing online course

 

DWH (Data Warehousing) Concepts

  • What is Data Warehousing?
  •  OLTP System vs OLAP System
  • 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

 

ETL Testing Concepts

Introduction

  • What is use of testing?
  • What is quality &standards?
  • Responsibilities of a ETL Tester

Software development life cycle

  • Waterfall model
  • V-model
  • Agile model & methodology
  • Prototype model
  • Spiral model

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, Abinitioetc;
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning