Can a entry in a fact table point to two entries in the same dimension ?
For example, consider this case :
A meeting M1 can have multiple participants P1, P2, P3.
How can i represent in star schema when i have a meeting fact table and participants dimension and meeting dimension.
I can only think of a fact table like this :
M1 Key, P1 key
M1 key, P2 key
M1 key, P3 key
This means, if a meeting has N participants, there will be N entries in the fact table.
Is this a right design ?
Do we have a better approach ?
Many-to-Many joins have to be dealt with by using a bridge table.
I can't say that I've implemented one - in fact, you can see me asking a similar question in an earlier thread posted yesterday