cancel
Showing results for 
Search instead for 
Did you mean: 

Cleared items extractor

0 Kudos

Hello,

how is it possible to extract cleared items using real delta extraction ?

Now (using job container and events 1906) we extract at the end of the day the items cleared during the day. But sometimes, items are cleared in the past and are not extracted.

If we extract items using extraction interval items are extracted every times and the need to make complete load in BW. And for using these way we don't know how to use events 1906 to plan correctly the extractor (first time its ok and then the extractor add one day at the 'to date' from interval).

Have you any idea how can we do ?

Thank's

Thierry

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

There are two ways you can try..

1. is you write a bit of code at the start of routine in order to identify the cleared

items on that particular day for ex. make a constant variable of that day

and check against this date and exclude all other remaining records from

update.

2. you can also build this logic at the extractor level

Note : This logic should only be applied only the past / historical records..it may

not be suitable for the current / delta records.

Thanks=points.

Cheer.