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
calculate CRC before or after transformation on data?
Moderators: chulett, rschirm, roy
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.
Otherwise they'll always be different.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers