locked
Many to Many relationship In DW RRS feed

  • Question

  • Hi

    Is it possible to have a many to many relationship in the snowflake model of DW?

     

    Thank you

     

    Tuesday, April 5, 2011 2:24 PM

Answers

  • Not sure whether or not you would still call it a snowflake but you can add a conjoint to table to have the IDs from the two tables to form a many to many join.

    Kimball calls it a bridge table.

    Tuesday, April 5, 2011 4:36 PM

All replies

  • Not sure whether or not you would still call it a snowflake but you can add a conjoint to table to have the IDs from the two tables to form a many to many join.

    Kimball calls it a bridge table.

    Tuesday, April 5, 2011 4:36 PM
  • Not sure whether or not you would still call it a snowflake but you can add a conjoint to table to have the IDs from the two tables to form a many to many join.

    Kimball calls it a bridge table.

    I think I should deal with the many-to-many relationship with the same way of relational data base: A-->B<--C, A and B is in a Many-to-many relationship with each other and C is bridge to connect them to each other, Is it right?

    Saturday, April 9, 2011 12:13 PM
  • Yep - that's a conjoint table (or bridge).
    Tuesday, April 12, 2011 4:23 PM