Check sum..

Question

Check sum..

techlead

Grasshopper

Points: 16
More actions
May 21, 2003 at 10:40 pm

#175732

I have a functionality, which splits my existing table into two and creates a new table.
Once this operation is over, i transfer the data across to the new table from the old table.
How can i make sure..that the data transfered between the two tables are correct..Please do send me if you have any generic way to check the same.
May 26, 2003 at 12:00 pm

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

j.o.s. Ten Centuries Points: 1242 More actions · Answer 1

I suppose that you could run a series of aggregate functions and the rows that you will be moving in the original table, then carry out the same functions on the rows once they have been moved, and then compare the results. They should be same. Not sure if this helps that much.

techlead Grasshopper Points: 16 More actions · Answer 2

quote:
I suppose that you could run a series of aggregate functions and the rows that you will be moving in the original table, then carry out the same functions on the rows once they have been moved, and then compare the results. They should be same. Not sure if this helps that much.

Thanks for the suggestion, that aggreation function you have specified, that part i'am using Check sum function to get the result. of old and new table. It is working fine.

techlead Grasshopper Points: 16 More actions · Answer 3

quote:
I suppose that you could run a series of aggregate functions and the rows that you will be moving in the original table, then carry out the same functions on the rows once they have been moved, and then compare the results. They should be same. Not sure if this helps that much.

Thanks for the suggestion, that aggreation function you have specified, that part i'am using Check sum function to get the result. of old and new table. It is working fine.

Antares686 SSC Guru Points: 125444 More actions · Answer 4

Actually depending on how you move your data the process will generally throw errors if the data is corrupted or cannot be moved. You may just need to look for an error.