Community

Using hash values in SSIS to determine when to insert or update rows

(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.