Delta extraction enables you to load into the BW systems that data which has been added or changed since the last extraction event.

  1. Create a DTP and go to the Extraction tab

    Make sure to check ‘Get All New Data Request By Request’

  2. Set the Filter ‘Run Date’


    Now every time you run the DTP it will pick up all new data request.



    Another method is to set the Run Date filter to be >= ‘2013-11-26’ on the DTP




    This will pull all new record from the date entered in the filter.


And on the Extraction tab the ‘Get All New Data Request by Request’ doesn’t have to be checked.