Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
So if i understand your question correctly
1. Load the data (Some set of records) from database into QVD.
2. Load the data by excluding the data which is already loaded in to the QVD.
Yes it is possible to do it. But it would be helpful to answer if you could provide a sample file
I have the first load script and the table structure, is it helpful?