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)
          s j

          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