Re: how is checksum calculated?

Hello Wreck

I totally agree with Danny,

Check Sums are a good solution when last modify date is not available.
But the CHECKSUM() function does not take into account case change for
char values or NULLS.

The BINARY_CHECKSUM() is a better form of the Checksum function. It
will handle Character case change and NULLs.

Have a look at Books Online under: BINARY_CHECKSUM()

Also have a look at the link below for a good overview on using the
checksums in the ETL process.

Best Practices for Using DTS for Business Intelligence Solutions
(updated web version)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

See Section "Data Transformation and Cleansing Approach"

Hope this helps,


Myles Matheson
Data Warehouse Architect

.

Relevant Pages
Loading