Home Forums Data Warehousing Strategies and Ideas Surrogat Key be Created in DW or Stage? RE: Surrogat Key be Created in DW or Stage?

  • July 13, 2012 at 1:30 pm

    #1512701

    I agree with Pablo, but it also depends on how you are handling slowly changing dimensions, if at all.

    I personally only use the natural key(s) in the staging and SK's in the final table.

    Jake