Post reply

Populating Surrogate Keys

  • March 15, 2016 at 9:56 am

    #316955

    I am fairly new to BI and SSIS, but am currently working on putting together a data warehouse. I have read that using surrogate keys is a must in a data warehouse rather than using a business key. I understand this and see the reason why.

    My question though is what is the preferred method for populate the fact tables with the correct surrogate keys when importing the data? My own thought is that I would use a business key from the fact table data and perform a lookup on the dim tables to provide the surrogate keys. Is that the preferred method?

  • March 15, 2016 at 10:21 am

    #1865331

    bsmith 63193 (3/15/2016)

    I am fairly new to BI and SSIS, but am currently working on putting together a data warehouse. I have read that using surrogate keys is a must in a data warehouse rather than using a business key. I understand this and see the reason why.

    My question though is what is the preferred method for populate the fact tables with the correct surrogate keys when importing the data? My own thought is that I would use a business key from the fact table data and perform a lookup on the dim tables to provide the surrogate keys. Is that the preferred method?

    Yes 🙂

    Populate the dim tables first and then use multiple lookups in your fact table load package to get the SKs.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply