Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a excel data from the month of Jan11 to July11
now i want to give incremental load in it by concatenating the upcoming xls eg:Aug11
I never tried incremental load before.
Please anybody help me in it.
thanks in advance
Hi,
Have a look at the documents available here.
Regards,
Kaushik Solanki
pls check following script which perfrom insert,update and delte operation in increamental load
QV_Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(ThisExecTime)#;
Concatenate LOAD PrimaryKey, X, Y FROM File.QVD
WHERE NOT EXISTS(PrimaryKey);
Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;
If ScriptErrorCount = 0 then
STORE QV_Table INTO File.QVD;
Let LastExecTime = ThisExecTime;
End If