Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Frends
I have some issue for usnig incremental load insert update and delete.
my data base table size 40 GB I want to use on this table incremental load (Insert ,Update,Delete).using below code but this code does not work properly.pls help
Let ThisExecTime = ReloadTime();
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
Thanks And Regards
Vimlesh Gupta