Populating Surrogate Keys
-
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?
-
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply