13 Replies Latest reply: Sep 24, 2014 10:19 AM by Colin Albert RSS

    Synthetic Keys problem

      Hi,

       

      i've a strange situation please see attachment. All table present in attachment are Transaction table (Fact Table). In this case i've to resolve synthetic keys? I can't join any table because different granularity. I can concatenate only Article_Promotion and Article_Discount, but this do not resolve any synthetic keys... i cannot concatenate the others tables.

       

      I know that exist link table, but with this solution i just replay the same solution that qlik suggest me with the syntethic keys..

       

      This situation (with synthetic keys) can create data inconsistency?

       

      Please help me thank you.