ETL TESTING ONLINE TRAINING
ENROLL NOW

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

1. 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

 

If you want to know more about ETL TESTING ONLINE TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com

ENROLL NOW