Page 1 of 1

calculate CRC before or after transformation on data?

Posted: Fri Sep 02, 2005 4:41 am
by Luk
Hi!

Is it better to calculate CRC (used for catch changes in source database) before any transformations need to be done on source data, after or doesn't matter?

Regards

Posted: Fri Sep 02, 2005 6:45 am
by chulett
If you are trying to compare source fields that are transformed before going into your target, to make an apples-to-apples comparison you'll need to do your initial transforms and then do the CRC check.

Otherwise they'll always be different. :wink: