Scribd
Upload
76 views1 page

ETL Testing Plan

This document discusses ETL testing and outlines the key concepts. It covers the basics of data warehousing and the differences between OLTP and OLAP. It also describes data modeling, schemas like star and snowflake, and SQL basics. The document defines the concepts and phases of ETL testing like requirements gathering, design, development, unit testing and integration testing. It discusses types of ETL testing defects and defect reporting.

Uploaded by

Sushmitha Kodupaka
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
76 views1 page

ETL Testing Plan

This document discusses ETL testing and outlines the key concepts. It covers the basics of data warehousing and the differences between OLTP and OLAP. It also describes data modeling, schemas like star and snowflake, and SQL basics. The document defines the concepts and phases of ETL testing like requirements gathering, design, development, unit testing and integration testing. It discusses types of ETL testing defects and defect reporting.

Uploaded by

Sushmitha Kodupaka
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

ETL Testing

1. Basics:
 Need for Data Warehousing
 What is Data Warehousing?
 Concepts of OLTP and OLAP
 Difference between Database and Data Warehousing
2. Data Warehousing Concepts
 Data Models
 Conceptual Data Model
 Logical Data Model
 Physical Data Model

 Data Schemas
 Star Schema
 Snow Flake Schema
 SCD 1,2 and 3 types
 Normalization
3. SQL Basics
 DDL Commands
 DML commands
 DCL Commands
 TCL Commands
 DQL Command(using clauses)
 Constraints
 Joins
 Temp Tables
 CTE
4. Introduction to ETL Testing
5. ETL Testing Concepts
 Requirements Gathering
 High Level Design
 Low level Design
 Development
 Unit Testing
 Integration Testing
 Test cases preparation
6. Types of ETL Testing
7. ETL Testing Defects
8. Defect Reporting

You might also like