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