Use Cases
This folder contiains all popular use cases for ETL Testing.
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 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 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
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
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 C...
Tue, 13 Feb, 2018 at 4:08 PM
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
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
Here we will go through the steps for creating Query Compare Test Case in ETL-Validator using Apache Drill Connection as Data Source. In order to learn ...
Tue, 28 Aug, 2018 at 11:35 AM
Objective Verify that the data in a column conforms to a specific format (eg. $A$$A) where $ represents a numeric digit between 0-9 and A represents a char...
Fri, 11 Jan, 2019 at 7:59 PM
The SOAP connection and Web Service test plan can be used to test SOAP requests. Example use cases include comparing the data in the SOAP response with data...
Tue, 5 Mar, 2019 at 5:29 PM