8 Replies Latest reply: Aug 17, 2014 8:45 AM by Jeroen Jordaan RSS

    Incremental load without a unique sequential id and modification date

    Jeroen Jordaan

      Hi everyone,

       

      I have a data loading situation were I'm stuck with, so I hope some off you can help me.

       

      For almost all our customers we use a incremental load approach based on a unique sequential id or modification date.

       

      Unfortunately with this customer there is no unique sequential id (by combining 3 fields we can create a unique key but it is not sequential) and there is no modification date. There is a date field but we cannot use it.

       

      I cannot use Where Exists with the SQL statement.

      The base QVD has about 4,5 million entries.

       

      Unfortunately we can also not create a additional field in the database with a trigger or something.

       

      Can anyone suggest an approach?

       

      Thanks in advance