ETL TESTING ONLINE TRAINING
Production Validation Testing (testing Data before moving in to production). Sometimes called table balancing or production reconciliation, this type of ETL testing is completed on Data as it is being moved in to production systems. The Data in the production systems has to be right in order to support your business decision taking. Informatica Data Validation Option provides the ETL testing automation and management capabilities to make positive that your production systems are not compromised by the Data update method.
Source to Target Testing (Data is transformed). This type of ETL testing validates that the Data values after a change are the expected Data values from the source. The Informatica Data Validation Option has a sizable set of pre-built operators to build this type of ETL testing with no programming skills necessary.
Application Upgrades (same-to-same as like ETL testing). This type of ETL testing validates that the Data coming from an older application or repository is the exact same as the Data in the new application or repository. Must of this type of ETL testing can be automatically generated, saving substantial check development time.
ETL TESTING ONLINE TRAINING COURSE CONTENT
Data WareHousing Concepts:
What is Data Ware House?
Difference between OLTP and DataWare Housing
Dependent Data Mart
Independent Data Mart
Data Base Design
Snow Flake Schema
Fact constellation Schema
SCD(slowly changing dimension)
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
ETL Testing Concepts
What is use of testing
What is quality & standards
Responsibilities of a ETL Tester
2.Software development life cycle
Agile model & methodology
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
We also provide other Data Warehousing Classes like Teradata