'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.
Solution 1:[1]
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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | NickW |