ETL Testing

Source table has 1000 records. Only 900 records are loaded in to target table. What is the test approach to find the missing records?

Showing Answers 1 - 3 of 3 Answers

Sagaya

  • May 10th, 2016
 

If both source and target table are of same DB( Teradata/Oracle/DB2) with same table structure MINUS query can be used, as
Select * from SOURCE TABLE MINUS Select * from TARGET TABLE.
Else if table structure differs, and both table uses the same column as its key column, MINUS can be applied on the key column to find the difference
Select Key column from SOURCE TABLE MINUS Select Key column from TARGET TABLE.

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