SSIS - Fact

[@samuna8950]

if i dont have primary key for lookup in fact table then?

[@Jel.Awesh.M]

What if you run the package two or more times? you will be getting some dupes, right? How to handle that?

[@castielwong]

Hi Jel. Thanks for your reply. Sorry I haven't touched SSIS for a long while. But as far as I can remember, you are right that there will be duplications if the package ran for more than one time. I don't quite remember what the component called to avoid such duplication. Yet it recalls to me that SSIS is able to handle situation like that. You can search Microsoft's document for the way out.

[@castielwong]

Something just hit me. Try the Slowly Changing Dimension, it should be the way out. ;)

[@Jel.Awesh.M]

@@castielwong Thanks for answering! I know this video is 3 year-old.