To check the target table for data quality?

My target table has loaded with 10000 records from source table.
Now, I want to verify the target table whether it has been loaded with correct data or it has any junk values
How do I test the above scenario.
As we can conclude that we cant check each and every record because of huge quantity.

Questions by govkj   answers by govkj

Showing Answers 1 - 15 of 15 Answers

krup

  • Jan 31st, 2014
 

1) you can do minus operation Or 2) you can design etl job t do compare and check

Ravi

  • May 15th, 2014
 

HI
U can use minus operator to know the difference between source and target.
Or
use inner join between source and target

  Was this answer useful?  Yes

surendra

  • Jul 8th, 2014
 

HI...
Write the Source query according the Business Logic ,write the target query for the same,export the two queries i.e is source and target to excel and with the help of open source tool db solo are beyond compare tool you can compare field to field and same the count too.

  Was this answer useful?  Yes

Anu Sharma

  • Apr 25th, 2016
 

First check the count of source and target
Then select first table minus second table and then we come to know if there is no record coming then values are loaded properly and if there are records appearing after executing the minus query then the records are not uploaded in the target table.

  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