DSXchange

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.