Thanks a lot GSquared....

From what I got is

I will have to add checksum column for each column that may change in my source in both the places....

Source as well as Target...

But my source is in different server (DB2) so I will have to stage it first and then add checksum for like 10 changing columns and similarly in my target i will add 10 checksum columns add will compare on them.????

Is this how checksum works...?

Actually my sroucre (DB2) has 7 million records...so i can't do row by row comparision(takes more than an hour)

Please let me know whr to add columns ? in SRC STG or in TARGET?

Thanks