Forum Discussion
Solved
Data Modelling
Previously I had a nice star schema type of relationships as per the above image. Now I have to add a new table Master_Table as per below to generate the below table. ...
1-to-many relationships
-
Master_Table[M_Code] → Dimension[Star_Code]
-
Dimension[Star_Code] → T1/T2/T3
Single-direction filtering
-
From Master → Dimension → Facts
-
No bi-directional shortcuts
Grain is respected
-
Each M_Code maps deterministically to Star_Code(s)
-
No ambiguous many-to-many paths
If these are met, the Dimension table still acts as the logical bridge.
-
cengizhanarslan
Super User
Super User1-to-many relationships
-
Master_Table[M_Code] → Dimension[Star_Code]
-
Dimension[Star_Code] → T1/T2/T3
Single-direction filtering
-
From Master → Dimension → Facts
-
No bi-directional shortcuts
Grain is respected
-
Each M_Code maps deterministically to Star_Code(s)
-
No ambiguous many-to-many paths
If these are met, the Dimension table still acts as the logical bridge.