Need help on a dimensional model scenario

View previous topic View next topic Go down

Need help on a dimensional model scenario

Post  neo.helios on Wed Oct 10, 2012 9:17 am

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

neo.helios

Posts : 11
Join date : 2010-11-02

View user profile

Back to top Go down

Need help on a dimensional model scenario

Post  RM7 on Wed Oct 10, 2012 11:55 am

The bridge table should be between User dim and the fact.

RM7

Posts : 3
Join date : 2012-10-10

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum