Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I dont have a date column but have a primary key.
Please explain how to do incremental load using primary key.
Thanks
Pavan
Hi,
First load your last qvd created, and then load the new data from your source.
load fields...
from yoursource
where not(exists(keyfield));
so this will load only the data of your new keys.
Finally, store your table for next incremental load.
Marc.
use the exists() function in your where clause. look it up into the manual. that will do.
Regards,
Tjeerd
Use Max function for this in the load script
Load
ID // Which is primary key
From Location Where ID > Max(ID);
Note:- But need to check how you need incremental load with ( Insert,Update,Delete ) or otherwise it is allready maintain in database.
Regards,
Anand
search using qvd files for incremental load in online help, case 3
QV_Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
//WHERE ModificationTime >= #$(LastExecTime)#
;
Concatenate LOAD PrimaryKey, X, Y FROM File.QVD
WHERE NOT Exists(PrimaryKey);
STORE QV_Table INTO File.QVD;