ETL-Validation After Data Loads To Target

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

Interview Candidate
Jun 21st, 2017
6
8083

First
Prev
Next
Last

Showing Answers 1 - 6 of 6 Answers

ashokkumar

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.

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)