Working on MERGE statement to Handle SCD

• sam 55243

  SSCrazy

  Points: 2697

  More actions

  March 4, 2013 at 8:56 am

  #290376

  Hi All,

  Could you please provide me an example or step, to handle both slowly changing dimension type 1 & type 2 in a single MERGE tsql query in SQL Server 2008.

  Please help.. 🙂

  Thanks

  Sam

• tmitchelar

  Hall of Fame

  Points: 3391

  More actions

  March 4, 2013 at 10:55 am

  #1593111

  Check this out:

  http://www.kimballgroup.com/2008/11/06/design-tip-107-using-the-sql-merge-statement-for-slowly-changing-dimension-processing/

• sam 55243

  SSCrazy

  Points: 2697

  More actions

  March 4, 2013 at 11:03 am

  #1593113

  Hi,

  If a dimension (SCD) table has both type 1 and type 2 columns then in that case how to use a single MERGE tsql to handle the both the types.

  I know how to handle type 1 & type 2 separately.

  Please advice.

  Thanks

  Sam