Forum Discussion
Solved
Relationship between two tables for multiple columns
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!
