5 Replies Latest reply: Oct 6, 2015 5:12 AM by Henric Cronström RSS

    Perfomance :Linked Table vs Synthetic Keys

      Hi All,

      i have multiple fact tables Call table F_A, F_B,F_C with three common columns as X,Y,Z

      and multiple dimension tables.

      so it formed a synthetic key in the data model, so in order to resolve synthetic key's i have created a linked table but,

      The model with synthetic keys takes much lesser time to load compare to linked table approach and data is also fine in the synthetic key's model,

      Can anybody tell me if it is to to have the synthetic keys, as i am getting the correct data with good performance.?

      and i wanted to know if trading of performance is alight than having synthetic keys in the model..?

       

      Regards,

      Ankit Jain