5 Replies Latest reply: Jan 4, 2017 4:00 PM by Bill Uran RSS

    Removing synthetic keys and circular references for 3 common fields

    Bill Uran

      The goal is to not have any synthetic keys nor circular references, so I need to first join PP_Map to Volume to get the appropriate PP for each service date(this will get rid of circular reference), then get rid of the generated synthetic keys for Charge_BU and Charge_deptid and now PP. Please advise me on how to do this.

       

      Thanks

       

      Here is a bit of my script:

       

      PP_Map:

      LOAD `Service_Date`,

          PP;

      SQL SELECT `Service_Date`,

          PP

      FROM HCOPT.PPE;

       

      Volume:

      LOAD `Charged_BU`,

          `Charged_deptid`,

          `Charge Code`,

          `Service Units`,

          `Service_Date`;

      SQL SELECT Charged_BU`,

          `Charge Code`,

          `Service Units`,

          `Service_Date`,

          `Charged_deptid`

      FROM HCOPT.CDM;

      LIB CONNECT TO 'Google Cloud (hcopt_senseadmin)';

       

      Payroll:

      LOAD Emplid,

          `Charged_BU`,

          `Charged_deptid`,

          `Hours`,

           PP;

      SQL SELECT Emplid,

          Emplid,

          `Charged_BU`,

          `Charged_deptid`,

          `Hours`,

           PP

      FROM HCOPT.Payroll;