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?