6 Replies Latest reply: Sep 26, 2011 8:57 PM by Elaine Ng RSS

    Date join key create synthetic key and loop in database structure

      Dear All,

       

      I've an issue with joining the date in the database

       

      Basically, there are 4 mains tables:

       

      All: PDID, Date, Value

       

      WorkProgress: PhaseID, Date

       

      CMMapping : PDID, PhaseID

       

      Calendar: Date, Year, Month,...

       

      Others details table

      PhaseDetails: PhaseID, Phasename, ...

       

      PrjDetails: PDID, PrjName, ...

       

      When I load my script, the QV prompted the database has loop structure and create synthetic key.

       

      Any idea how to resolve this issue?