ETL TESTING ONLINE TRAINING
DATAWARE HOUSING CONCEPTS:
- What is Data Ware House?
- Difference between OLTP and DataWare 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
DATA WARE HOUSE LIFE CYCLE
DIFFERENT TYPES OF TESTING TECHNIQUES IN ETL
- Minus Queing
- Count Queing
ETL TESTING CONCEPTS
1. Introduction
- What is use of testing
- What is quality & standards
- Responsibilities of a ETL Tester
2. Software development life cycle
- Waterfall model
- V-model
- Agile model & methodology
- Prototype model
- Spiral model
3. Testing methodologies
- White box testing
- Black box testing
- Grey box 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
If you want to know more about ETL TESTING ONLINE TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com
