Home Forums SQL Server 2005 Business Intelligence How to implement scd in SSIS(2008) without SCD or CDC transformation. RE: How to implement scd in SSIS(2008) without SCD or CDC transformation.
Robert.J.Blackburn
SSC Journeyman
Points: 75
More actions
March 26, 2014 at 1:35 pm
#1700449
I wrote up how to use the HASH function to determine changes. Also, performs much faster then SCD.
http://anexinetbi.blogspot.com/2013/04/faster-slowly-changing-dimension-with.html