Search SSWUG.ORG:



DATABASES

Using hash values in SSIS to determine when to insert or update rows This is an off-site link.  Please review our Terms of Service for additional information.


(Koen Verbeeck) When you want to load data into your data warehouse, for example into one of your dimensions, you need to determine if an incoming row is either an update – a historical change – or an insert, which is a new occurrence of a record. An update row is a source record for which the business key – or the natural key as some folks prefer – is already present in the destination table.

Read this article..







comments powered by Disqus