Use Cases

This folder contiains all popular use cases for ETL Testing.

Compare flat file and a table
ETL Validator: Flat File to Table comparison from Product Marketing @ datagaps
Sun, 17 Aug, 2014 at 9:20 AM
Compare Table to Table (Source to Target)
Often, as part of our testing, we want to be able to compare data in two tables or output of two queries between source and target system.  This deck expla...
Thu, 22 Sep, 2016 at 2:24 PM
Validate a Flat File
ETL Validator: Flat File Validation from Product Marketing @ datagaps
Sun, 17 Aug, 2014 at 9:20 AM
Data counts validation with allowed variance
One of the customer recently asked us how to use ETL Validator for validating data counts with allowed variance. For the purpose of this post lets consid...
Wed, 7 Dec, 2016 at 1:59 PM
Test for Data Completeness
One of the most basic tests of data completeness is to verify that all the expected data gets loaded in the data warehouse. For example, validating all re...
Sun, 17 Aug, 2014 at 9:20 AM
Test Referential Integrity
The Foreign Key Test plan provides an easy to use wizard driven test plan for validating the parent - child relations between tables. In a star schema, this...
Thu, 22 Sep, 2016 at 9:30 PM
Create a Data Model in ETL Validator
Thu, 12 Mar, 2015 at 8:06 PM
Check Data Quality using Data Rules Test Plan
Data Rules Test Plan can be used to validate the quality of the data in a given data source :  This youtube video provides the same details ...
Thu, 22 Sep, 2016 at 3:02 PM
Connecting components in ETL Validator "Component Test Case"
Fri, 13 Mar, 2015 at 1:20 PM
Track DDL changes using Compare Metadata Test Plan
ETL Validator gives quick and easy way to compare Metadata changes between source & target data sources OR changes occurring within the same Databas...
Mon, 30 Apr, 2018 at 9:13 AM