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 create a test case with transformation logic in source data that will help in testing the derived fields in target data.

The slideshow below walks you through creating the Query Compare test case.

ETL Validator Usecase - Transformation logic in input data source