March 15, 2016 at 9:56 am
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
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.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply