Forum Discussion
Creating relationships using Surrogate Key and Composite key
Hello Community,
Good Day!
I am really stuck with a question in my head.I have watched several videos but didnt get this answer.
Suppose I have 2 tables (1 dimension and other fact table) so how should i create a perfect relationship between them if they both have duplicates.
Shall I create a composite keys in both the table and join them or shall i remove duplicates from the dim table,create a surrogate key then join the dim table and fact table using common identifier and then include the surrogate key inside fact table to create active relationship between dim and the fact table using surrogate key?
1 Reply
Ideally Dim table should not have duplicates. Have you tried craeting bridge table between fact and dim?
