ETL TESTING
============================================
what is Testing ?
what is the need for Testing?
Testing Methodologies
Data Ware Housing Concepts:
• What is Data Ware House?
• Difference between OLTP and Data Ware Housing
• Data Extraction
• Data Transformation
• Data Loading
Data Marts
• Dependent Data Mart
• Independent Data Mart
Data ware housing Approaches
Top Down Approach
bottom up Approach
Data Base Design
• Star Schema
• Snow Flake Schema
SCD(slowly changing dimension)
• Type-1 SCD
• Type-2 SCD
• Type-3 SCD
Basic Concepts in SQL
• SQL Concepts
• Overview of ETL Tool Architecture
• Testing Functionality on Different Transformation Rules
Data Ware House Life Cycle
Different Types of Testing Techniques in ETL
ETL Testing Introduction
• What is use of testing
• What is quality & standards
• Responsibilities of a ETL Tester
Software development life cycle
Understanding various documents such as Business Requiremet Document,
Design Documents,Mapping sheets
• Types of 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
For Classess and queries contact :
Cell :9550580658
Mail : bunny.friendly@gmail.com
