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.

govkj
Profile Answers by govkj Questions by govkj
Oct 21st, 2013
5
11446

Questions by govkj answers by govkj

Concepts

Answer

First
Prev
Next
Last

Showing Answers 1 - 5 of 5 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

madhulatha
Profile Answers by madhulatha Questions by madhulatha

Jul 8th, 2014

could you please explain you can design etl job t do compare the compare and check

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.

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.