Use Cases

This folder contiains all popular use cases for ETL Testing.

Query parameterization in ETL Validator
Query parameterization in ETL Validator from Product Marketing @ datagaps
Thu, 14 Jan, 2016 at 4:36 PM
Mass Import of Source and Target Queries
           Importing Queries using Mass Import Tool from Product Marketing @ datagaps
Tue, 19 Jan, 2016 at 7:35 PM
Advanced ETL Testing using a Component Test Case
Component Test Case provides a visual test case builder for defining the data sources and validations. Some of the common scenarios where the Component Te...
Thu, 22 Sep, 2016 at 3:01 PM
Compare Profile of data between Source and Target
Data Profile is the process of gathering statistics such as Max, Min, Avg for a given dataset. ETL Validator provides a test case called Data Profile for co...
Thu, 22 Sep, 2016 at 2:55 PM
ETL Transformation Testing
Transformation testing can be tackled using the following two approaches  White Box testing : Implement the transformation in the test case...
Wed, 5 Oct, 2016 at 1:18 PM
Checking for Mandatory Fields
ETL Validator gives quick and easy way to create test cases for checking mandatory fields. Here, we will create a test case that will identify records from ...
Mon, 8 Jan, 2018 at 1:33 AM
Validating Field and Data Format
ETL Validator gives quick and easy way to create test cases for checking field format or identifying invalid data. Here, we will create a test case that wil...
Mon, 8 Jan, 2018 at 1:38 AM
Checking for Conformance with List of Values
ETL Validator gives quick and easy way to create test cases for checking conformance with list of values. Here, we will create a test case that will identif...
Tue, 9 Jan, 2018 at 9:26 AM
Comparing Input and Output data
ETL Validator gives quick and easy way to create test cases for mapping and comparing data between Input and Output data sources. Here, we will create a tes...
Thu, 11 Jan, 2018 at 12:39 PM
Testing Transformations or Derived fields
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 wi...
Tue, 16 Jan, 2018 at 10:12 AM