The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Ideally Dim table should not have duplicates. Have you tried craeting bridge table between fact and dim?