Insert Update delete Incremental load issue

Wed, 03 Apr 2013 05:31:38 GMT

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

topic Insert Update delete Incremental load issue in QlikView

Insert Update delete Incremental load issue