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

    Elaine Ng

      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?