Example for Determining Selection Intervals with a Generic Delta

Example for Determining Selection Intervals with a Generic Delta:

1. For every delta extraction, there is a selection criteria generated: last extraction status (RSA7)” < x <= Today.

2. Offsets for upper and lower delimiter are subtracted from the respective sides

3. Example 1 shows the normal behavior (both offsets = 0), example 2 shows both safety intervals (offset for lower delimiter = 2, offset for upper delimiter = 1)

4. Offset for lower delimiter can only be defined for delta method “new status for changed records

 

Tips:

1. If delta field is Date (Record Create Date or change date), then useUpper Limit of 1 day.This will load Delta in BW as of yesterday. Leave Lower limit blank.

2. If delta field is Time Stamp, then useUpper Limit of equal to 1800 Seconds (30 minutes).This will load Delta in BW as of 30 minutes old. Leave Lower limit blank.

3. If delta field is a Numeric Pointer i.e. generated record # like in GLPCA table, then useLower Limit. Use count 10-100. Leave upper  limit blank. If value 10 is used then last 10 records will be loaded again. If a record is created when load was running, those records may get lost. To prevent this situation, lower limit can be used to backup the starting sequence number. This may result in some records being processed more than once;therefore, be sure this DataSources is only feeding an ODS Object.