2 Replies Latest reply: Nov 22, 2016 9:09 AM by Giampiero Cina RSS

    Link table with different dimensions for different Facts

    Ganesh Bagavathi

      Hello,

      I am trying to find out if it is possible to create a link table which will have 2 Fact tables with similar dimensions and keys, while the third Fact will not have the same set of dimension keys. is it possible to create a separate composite key just to connect the fact2 and fact3? Or is it possible to use the same key created for the Fact1 and 2 for joining Fact3 as well.

       

      LinkTable.JPG

      Thanks.