3 Replies Latest reply: Jan 23, 2018 3:27 AM by Mikel De RSS

    Advice about data model

    Mikel De

      Hello,

       

      I have been trying to fix a model that had several synthetic keys and even a circular reference. After joining some tables, creating new keys and using mapping load when possible, I ended up with a model looking like this:

       

      Capture.PNG

       

      So I have two keys (Supplier_Group_Key and PO_Item_Key) that link three tables each. Even though the model works and the numbers are correct, as I am not really a data model expert, my question is, is this a good practice or there is a better way to do it?

       

      This is just for learning purposes. Thanks!