Scribd
Upload
855 views1 page

ETL Testing & Data Warehousing Guide

This document discusses Extract, Transform, Load (ETL) testing for data warehousing. It covers the differences between online transaction processing (OLTP) systems and data warehousing, the ETL process including extraction, transformation and loading of data, types of data marts and database schemas, slowly changing dimensions, ETL tool architecture and components, and testing techniques for validating different ETL transformations and the overall data warehousing life cycle.

Uploaded by

Nag Dhall
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
855 views1 page

ETL Testing & Data Warehousing Guide

This document discusses Extract, Transform, Load (ETL) testing for data warehousing. It covers the differences between online transaction processing (OLTP) systems and data warehousing, the ETL process including extraction, transformation and loading of data, types of data marts and database schemas, slowly changing dimensions, ETL tool architecture and components, and testing techniques for validating different ETL transformations and the overall data warehousing life cycle.

Uploaded by

Nag Dhall
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

ETL TESTING What is Data Warehousing?

Differences between OLTP and Data Warehousing DATA ACQUISITION DATA EXTRACTION DATA TRANSFORMATION DATA LOADING Data Marts Dependent DM Independent DM Database Design Star Schema Snowflake Schema Fact Constellation Schema SCD (Slowly changing Dimensions) TYPE1 SCD TYPE2 SCD TYPE3 SCD Basic concepts in SQL Overview of ETL Tool Architecture Components in ETL Tool White Box and Block Box testing functionality in different transformation rules: SAMPLE Loading from source to target SORTER Transformation FILTER Transformation ROUTER Transformation EXPRESSION Transformation JOINER Transformation UNION Transformation AGGREAGATOR Transformation RANK Transformation STORED PROCEDURE Transformation SEQUENCE GENERATOR Transformation Flat File SQL Transformation Data Warehousing Life Cycle Different types of testing techniques in ETL MINUS Query COUNT Query

You might also like