ETL Testing Online Training
ETL Testing Online Training
ETL Testing Online Training
ETL Testing Online Training Course Content:
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
Data Ware Housing Concepts
- What is Data Ware House?
- Difference between OLTP and Data Ware 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
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 Data Stage, Informatica, Abinitio etc;
- How to detect the bugs through database queries
- ETL Performing Testing & Performing Tuning