9 Replies Latest reply: Jan 14, 2016 10:21 AM by A.M. van Keep RSS

    Concatenate Many to Many Fact Tables

    Bill Markham

      Hi

       

      I am sorting a data model that has evolved over time into something that now looks like the Flying Spaghetti Monster.

       

      A lot of the Fact Tables have many to many relationships between them.

       

      I would like to concatenate these Fact Tables but that seems easier said than done.  Is this sensible or would Link tables be better ?

       

       

      Many Thanks,   Bill