6 Replies Latest reply: Nov 24, 2016 7:41 AM by Zhihong He RSS

    Data Model Linking Problem!!!

    Saurav Kumar

      I have 4 Facts and 3 dimension table.
      I have made a link table to link these fact table.
      Now the problem is, I have made link key from 3 fields in first 3 facts. But in the fourth Fact table I have only one field out of these 3 fields, So how should I link my fourth Fact table to the Link Table. Or which approach should I follow in linking my fourth Fact table to the model.

      I have linked all my Dimension table to my link table
      I am explained in the diagram below:

       

      Linking Problem.png


      Please suggest me the best approach for linking my last Fact Table to the model.