chaneb
Reputation: 67
How to populate fact table with Surrogate keys from dimensions?
Could someone please help me understand how to populate the fact table with Surrogate keys from dimensions using SSIS? I load my dimension tables and assign for each a surrogate key. I want to add these surrogate keys to my fact table but I don't know from where to start.
Upvotes: 0
Views: 445
Answers (1)
NickW
Reputation: 9788
You just join your fact source record to the relevant dimension tables and get the surrogate keys, which you then insert into your fact table
Upvotes: 1
Related Questions
- How to populate fact table with Surrogate keys from dimensions
- Loading Fact table with SCD2 from Lookup dimension inSSIS
- How can I populate my Fact table?
- SSAS - Is there a way to have a dimension relate to a fact table based on two columns in the fact table?
- How to use a SSAS fact table as a dimension
- Look up surrogate keys and Populate fact table
- creation of dimension and fact table through source tables
- SSIS Lookup multiple dates in my fact table, how to pull this off using one date dimension?
- Loading a fact table in SSIS when obtaining the dimension key isn't easy
- Populate fact table with foreign keys