Re: how is checksum calculated?

Many warehouses go that direction when they can't relay on last mod dates or
primary keys. My general advice is use it but understand that the values in
the DW could be slightly incorrect and do a full refresh of any table built
this way from time to time. I have seen checksums in SQL or otherwise not
find the correct differences. Almost every time I've found that situation
it was due to Nulls.


"Wreck" <Wreck@xxxxxxxxxxxxxxxx> wrote in message
news:1E91E7F2-9CA2-4ACA-9185-249AAC2BA96E@xxxxxxxxxxxxxxxx
> Hi,
>
> I'm looking at using checksum to check for changes in our data warehouse,
> and have seen comments on the checksum not always being unique.
>
> Just wanted to know how it is actually calculated to see if it is likely
> to
> get duplicated checksums.
>
> Thanks.
>


.

Loading