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

    Concatenate Many to Many Fact Tables

    Bill Markham



      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