ETL Testing

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
  1. Software development life cycle
  • Waterfall model
  • V-model
  • Agile model & methodology
  • Prototype model
  • Spiral model
  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *