1 Reply Latest reply: Apr 30, 2012 1:37 AM by s j RSS

    SAP Connector - DSO Delta Load (Incremental Load)

    Vipin Mishra

      how to create a incremental load

        • SAP Connector - DSO Delta Load (Incremental Load)

          Let ThisExecTime = Now( );



          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