7 Replies Latest reply: Sep 17, 2014 8:43 AM by Laura Sébille RSS

    incremental load without date fields ?

    Laura Sébille

      Hello everyone,

       

      I have an application in which I load data from the database without almost any transformation and then store the tables in qvd files.

       

      I don't have any date fields like "creating data" or "modification date".  I was wondering if there was any tips to use kind of incremental load ?

       

      Can I compare the values to the ones existing in the qvd and then add only the new lines ? But if I have to compare each record of the table to each record of the QVD, would that improve the performance ?

       

       

      Thank you for your anwers