US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Can a entry in a fact table point to two entries in the same dimension ?

  1. #1
    Join Date
    Sep 2012
    Posts
    26

    Default 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 ?


    Thanks

  2. #2
    Join Date
    Apr 2008
    Posts
    2,633

    Default

    Many-to-Many joins have to be dealt with by using a bridge table.
    See http://www.kimballgroup.com/2012/02/...lding-bridges/
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •