Forum Discussion
Dicko
Helper II
Helper IIWhat relationship to use?
I have a FactDossiers table
| FactDossiers |
| id_dossier |
| ... |
Each dossier can have multiple timelines
| Timelines |
| id_dossier |
| created_at |
| ... |
What relationship should exist between the two?
Now I have a FactDossiers 1 > * Timelines relationship, which seems incorrect to me.
Should I merge Timelines with the FactDossiers table, even if it means the number of rows in FactDossiers would multiply several times?
Or is there another way?
Dicko , two facts should not join. Better to merge and have a single table.
But do that if you do not have any other dimesions. if these are only two table, then you can manage with this
1 Reply
- amitchandak
Super User
Dicko , two facts should not join. Better to merge and have a single table.
But do that if you do not have any other dimesions. if these are only two table, then you can manage with this