Need help on a dimensional model scenario
2 posters
Page 1 of 1
Need help on a dimensional model scenario
Need suggestions to model the scenario explained below
I have a dimension "EXPERIMENT_DIM" which has a hierarchy Conceptual Phase -> Master Phase -> Implementation Phase. At each phase, I need to link a set of users responsible for running the phase and with a flag for one of them as primary user. The user data is available in "USER_DIM"
Do I need a bridge table between EXPERIMENT_DIM and USER_DIM to handle this scenario? Please suggest
Thanks in advance
I have a dimension "EXPERIMENT_DIM" which has a hierarchy Conceptual Phase -> Master Phase -> Implementation Phase. At each phase, I need to link a set of users responsible for running the phase and with a flag for one of them as primary user. The user data is available in "USER_DIM"
Do I need a bridge table between EXPERIMENT_DIM and USER_DIM to handle this scenario? Please suggest
Thanks in advance
neo.helios- Posts : 11
Join date : 2010-11-02
Need help on a dimensional model scenario
The bridge table should be between User dim and the fact.
RM7- Posts : 3
Join date : 2012-10-10
Similar topics
» How would you model this simple scenario ?
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Seeking suggestions on how to potentially model 0:M scenario
» Meta-model of Kimball dimensional model
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Seeking suggestions on how to potentially model 0:M scenario
» Meta-model of Kimball dimensional model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum