Testing Tools

  • 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
  • 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:
    • Sample Loading from source to Target
    • Sorter Transformation
    • Filter Transformation
    • Router Transformation
    • Expression Transformation
    • Joiner Transformation
    • Union Transformation
    • Aggregator Transformation
    • Rank Transformation
    • Stored Procedure Transformation
    • Sequence Generator Transformation
    • Flat File Transformation
    • SQL Transformation
  • Data Ware House Life Cycle
  • Different Types of Testing Techniques in ETL
  • Minus Queing
  • Count  Queing