Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey there,
currently I have two tables that are related thru the "employee_id".
The fact table "employee_type" could have up to 4 rows for one day. Like this for example:
Region | Date | Employee_ID | Status |
1 | 2023-10-24 | 1234 | A |
1 | 2023-10-24 | 1234 | B |
1 | 2023-10-24 | 1234 | C |
1 | 2023-10-24 | 5678 | D |
The related dimension table looks something like this:
Employee_ID | Name |
1234 | Mike |
5678 | Jim |
My fact table contains about 35 million rows and is getting bigger everyday. My idea is to change the fact table to something like this:
Region | Date | Status A | Status B | Status C | Status D | |
1 | 2023-10-24 | 1234 | 1234 | 1234 | 5678 |
Is it still possible to link the dimension table to all 4 columns which contain the employee_id? Do I link one column as active and the other 3 as inactive relationship?
Thanks in advance!
Solved! Go to Solution.
Hi @KevinMc84
Yes, there is no limit to inactive relationships.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @KevinMc84
Yes, there is no limit to inactive relationships.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly