ETL-Validation After Data Loads To Target

What are the validations you perform after data loads for source to target?

Showing Answers 1 - 2 of 2 Answers


  • Jul 5th, 2017

Such this type of testing is carried out to validate the data whether source data is transformed to expected target or not and also check the values.

  Was this answer useful?  Yes

Suresh Reddy

  • Sep 28th, 2017

Once the data is loaded in the target tables, we have to do below validations:
1. Counts between source and Target
2. Duplicates check
3. Null Values check
4. Mandatory Values check
5. Data compare (source minus Target and Target minus source)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions