ETL Testing Course Content :

ETL Testing Course 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: ETL Testing Online Training

Introduction

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

More About

ETL Testing Online Training