ETL Testing Training

ETL Testing Online Training

Data Warehouse Concepts

  • What is Data Warehouse?

Introduction to Data warehouse Characteristic features of Data warehouse

  • Time Variant
  • Non-Volatile
  • Subject Oriented
  • Integrated

Differences between OLTP and OLAP

What is Data Warehousing?

  • Design Schema
  • ETL – Extraction Transformation & Loading
  • Reporting

Data Acquisition

  • Data Extraction
  • Data Transformation
  • Data Cleansing
  • Data Scrubbing
  • Data Merging
  • Data Aggregating
  • Data Loading
  • Initial Load / Full Load
  • Incremental Load / Delta Load

Data Marts

  • Top down Approach / Dependent Data Mart
  • Bottom up Approach / Independent Data Mart

Dimension Table & Fact Table

Database Design

  • Star Schema
  • Snow Flake Schema

Slowly Changing Dimensions [SCD]

  • SCD Type 1
  • SCD Type 2
  • SCD Type 3

Phases in Dimensional Modeling

  • Conceptual Modeling
  • Logical Modeling
  • Physical Modeling

Basic concepts in SQL

Data Warehousing Architecture

Types of Transformations

  • Active Transformation
  • Sorter Transformation
  • Filter Transformation
  • Router Transformation
  • Rank Transformation
  • Joiner Transformation
  • Union Transformation
  • Aggregator Transformation
  • SQL Transformation
  • Passive Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Stored Procedure Transformation
  • Connected Transformations
  • Unconnected Transformations

Real-time Scenarios

  • Finding difference between source tables and target tables
  • Finding Duplicate Records
  • Finding Junk Values
  • Incompatible and duplicate data

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message