How to implement scd in SSIS(2008) without SCD or CDC transformation.

• naresh0407

  Old Hand

  Points: 362

  More actions

  March 25, 2014 at 11:10 am

  #286913

  Hi,

  How can we capture changed data and new data in SSIS without SCD trasformation.Will we use SCD transformation in realtime or will follow any other methology(like using LookUp,ConditionSplit).Please let me know the process.

  Thanks

• 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