0 Replies Latest reply: Aug 7, 2013 8:51 AM by Mark Brown RSS

    Incremental Load - JD Edwards GL Account Ledger - F0911

      Looking for help constructing an incremental load statement for Qlikview over a JD Edwards Database..

       

      2 Core issues to overcome -

       

      Suitable criteria in the SQL / Script that will pass through yesterday's "Julian" date to restrict records based on the Updated Date.

       

      Suitable unique key to use with the WHERE NOT EXISTS syntax to allow me to prevent doubling up modified records.

       

       

       

      Any help much appreciated.

       

      Mark