SAP Connector - DSO Delta Load (Incremental Load)

vipin_mishra479 — Mon, 30 Apr 2012 05:12:48 GMT

how to create a incremental load

suniljain — Mon, 30 Apr 2012 05:37:58 GMT

Let ThisExecTime = Now( );

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

topic SAP Connector - DSO Delta Load (Incremental Load) in QlikView