2 Replies Latest reply: Jan 22, 2014 1:41 PM by jorge kamensky RSS

    Incremental Load w Business Key

      Hey folks!

      Do you know if is possible to do an Incremental Load using Business Key like the situation bellow:

      SELECT ProductID, ProductName

      FROM Northwind..Products p

      WHERE NOT EXISTS (

         SELECT 1

         FROM Northwind..[Order Details] od

         WHERE p.ProductId = od.ProductId)

      In the first load it will insert all records to the QVD and after that this query will only retrieve data that are not loaded.

      I´m asking this because I have a table that does not have the columns INSERTDATE and the PK is a varchar.