Hi everyone. I have encountered a scenario that need to populate key from dimension table to Fact table. I am wondering is there any good practice that we can use to solve this scenario.
Hope you guys can share your opinions and experience.
Thanks very much in advance.
![Smile :)](./images/smilies/icon_smile.gif)