ETL Validator extracts the test data from source and target into a common workschema which allows for comparing fo the data before and after transformation in the following ways :
- Write your own SQL against the Source/Target and comparing the data
- Specifying the data rules to check the validity of the transformed data