Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
User | Count |
---|---|
67 | |
61 | |
47 | |
33 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |