Example of delta processing

The following example describes how to coordinate delta processing between the Load stage and the Oracle Applications stage.

  1. Start the processing from the Scheduler (Maintain InfoPackage) dialog in SAP BW. To do this, select Initialize Delta Process as the Update Mode on the Update page.
  2. Make your selection from the Data Selection page of the Scheduler (Maintain InfoPackage) dialog. Use the JJJJ/MM/DD date format.
  3. In DataStage®, open the Oracle Applications Direct Access stage and select the Delta tab on the Outputs page to enable delta processing:
  4. Select a table from the Available delta tables list and move it to the Selected Delta tables list, then specify the appropriate path and filename in the Path to delta file field:
  5. From the Scheduler menu in SAP BW, select Initialization Options for Source System, then select Start Data Load immediately from the Schedule page:
  6. Mark and delete the entry on the Initialization for this Source window.
  7. An informational message appears, verifying the deletion.
  8. Ensure the delta file is deleted on the server. You can view log information in Notepad.