Could you please tell me the Main use of CRC32 function.
Adv thanks....
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Moderators: chulett, rschirm, roy
kumar_s wrote:You will get a unique number (checksum) for each input.
This is used for several purpose, for example, duplicate check, dedupliacation, Surrogate key generation, lookup....
You can easily get more information by doing a search on the same keyword.
Again - statements like these truly show the ignorance people have about CRC and checksum. First - CRC is NOT a checksum, checksum implies addition and CRC is not additive. CRC is based on division and remainders etc...You will get a unique number (checksum) for each input.
This is used for several purpose, for example, duplicate check, dedupliacation, Surrogate key generation, lookup....
You can easily get more information by doing a search on the same keyword.
raging? - Craig - I like to think of it as more frustration then anything. I have simply had an uphill battle educating developers and customers about the virture of CRC in SCD processing. Every time a consultant utilizes the routine in a manner in which it was not developed simply helps to solidify the image that it doesn't work.raging life by Michael
There is a good Wikipedia entry for CRC. If you read it you will se how wrong you are. http://en.wikipedia.org/wiki/Cyclic_redundancy_checkkumar_s wrote:You will get a unique number (checksum) for each input.
This is used for several purpose, for example, duplicate check, dedupliacation, Surrogate key generation, lookup....
You can easily get more information by doing a search on the same keyword.
...and very bad when used incorrectly.kduke wrote:No big deal Kumar. Keep up the good work. It was just a minor point. This is a powerful and complex routine which is very useful when used correctly.