business key in scd RRS feed

  • Question

  • i have two tables one in staging and one in destination .both are identical and both have  identity column as primary key. so i am trying to use SCD  for historical .but the problem i am facing is that in staging and destination there is identity column and i want them to use as Business key.but when i want to select that as Business key in Scd.those columns are not showing up.i dont know why.these are only column which i can select as business key.bcz other columns are of type 2 and type 1.so what should i do?
    Friday, March 16, 2012 3:57 PM


  • It's not possible for you to model a slowly changing dimension with a business key as a primary key in the table.  Period.

    An SCD requires that there are multiple rows with the same business key.  These rows are different versions of the same business entity at different periods in time.  SCD modeled tables are incompatible with defining a primary key on the business key.

    Todd McDermid's Blog Talk to me now on

    • Proposed as answer by Eileen Zhao Monday, March 19, 2012 5:40 AM
    • Marked as answer by Eileen Zhao Monday, March 26, 2012 12:47 AM
    Friday, March 16, 2012 8:07 PM