Use Cases

This folder contiains all popular use cases for ETL Testing.

Checking for Duplicate Records
ETL Validator gives quick and easy way to create test cases for identifying Duplicates in data sources. Here, we will create a test case that will identify ...
Thu, 25 Jan, 2018 at 4:59 AM
ETL Validator Usecase - Data Profiling and Comparison
ETL Validator gives quick and easy way to create test cases for profiling and comparing source & target data sources. Here, we will create a test ca...
Fri, 26 Jan, 2018 at 11:57 AM
ETL Validator Usecase - Validating Measures, Counts with Variance
ETL Validator gives quick and easy way to create test cases for comparing counts and measures of source & target data sources. A variance can be specifi...
Thu, 1 Feb, 2018 at 5:51 AM
Testing Derived Fields Using Transformation Logic
ETL Validator gives quick and easy way to create test cases for mapping and comparing transformed data between Source and Target data sources. Here, we will...
Thu, 8 Feb, 2018 at 10:04 AM
Comparing Excel File to other Data Sources
Often there is a need to compare data in Excel file to data from other data sources such as a relational database. This can done using ETL Validator's ...
Tue, 13 Feb, 2018 at 4:08 PM
Parameterize file name in flat file components
When validating flat files, one of the frequent question is about how to use the run the same test case for different flat files without the having to chang...
Tue, 27 Feb, 2018 at 7:10 PM
Executing the same test plan/test case against multiple environments
A typical development cycle consists of developing the ETL in a Development environment and progressing it through Test and Production environments. Each of...
Wed, 28 Feb, 2018 at 1:32 PM