Post reply

Many to Many relationship

  • October 2, 2015 at 3:09 pm

    #321643

    Is it better to create a Type2 dimension or a periodic Fact table to maintain history of a many to many relationship?

    In case of periodic fact table, it will be good enough to track changes every day and it's ok to loose intra-day changes in this case.

  • October 15, 2015 at 11:14 am

    #1833574

    It really depends on what exactly you are trying to do.

    If you are looking to track the changes between the relationship of different type-2 dimensions, then a (fact-less) periodic snapshot table will be sufficient. If the changes are too rapid or your dimensions very large, you could look at temporal fact tables as a possible solution.

  • October 24, 2015 at 6:27 am

    #1835353

    A junction table maybe?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply