Use Cases
This folder contiains all popular use cases for ETL Testing.
ETL Validator: Flat File to Table comparison from Product Marketing @ datagaps
Sun, 17 Aug, 2014 at 9:20 AM
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
ETL Validator: Flat File Validation from Product Marketing @ datagaps
Sun, 17 Aug, 2014 at 9:20 AM
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
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
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
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
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