Report the ad
Best etl testing institute in hyderabad etl testing project training - Hyderabad
Wednesday, 16 April, 2014Item details
City:
Hyderabad, Andhra Pradesh
Item description
I. ETL TESTING
What Is ETL process?
Objective of ETL Testing
SQL for ETL Testing
Overview of Data Model for banking DWH project
Inputs for ETL testing
Test strategy document
Test plan document
Mapping Specification
Macro and micro design
Copy books
Schema file
Test data file (COBOL,.CSV,.TXT)
II. ETL Testing Techniques
1. Count Test
2. Primary Key Validation
3. Duplicate Records Testing
4. Column Testing
5. Technical Data Quality (TDQ)
6. Business data quality
7. Default values test
8. SCD
9. Data marts testing
10. Fact table testing
III. Execution and debugging failed tests
IV. Testing evidence for Pass/Fail (Test reports)
V. Challenges faced during testing
Interview Questions and Complexity faced during testing
VII. DWH Basics
What is DWH?
Benefits of DWH
DWH concepts
DWH architecture
VIII. Dimensional Data Modeling
Fact Table
Additive, Semi Additive, Non Additive
Cumulative, Snapshot, Transactional
Dimension Table
Confirmed Dimension, Junk Dimension
Schema
Star Schema, Snow Flake Schema
IX. Data Mart
Dependent Data Mart
Independent Data Mart
XI. Industry standard SCD
Type I
Type2 II
Type III
info@gearitsystems.com
9676367705