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?