This content has been marked as final. Show 2 replies
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 (
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.