Skip to Content
Former Member
Oct 28, 2010 at 06:57 PM

Issue with Generic Extractor Delta Load


Hi Gurus:

I am having issue with DELTA extraction using the Generic extractor form a TABLE. Some Background.....

I want to extract Daily Delta from a TABLE. The delta is set up on a DATE field (DOCUMENT DATE) with

Upper Limit as +1. This should let me pull DAILY deltas from the table. In normal operation in future System

Date would be the Document Date, however, for now I am testing with some older records. The Document

Dates are for 2008. In my table I pull data for Document Date of 01/02/2008 and when I initialize the ODS I

get the proper data records. Then I load the TABLE with records for 01/03/2008. So, the Document Date has

changed by 1 Day. I know the Documebnt Date has increased by 1 Day but my DELTA extraction does not

extract any records.

Please let me know where am I going wrong......? This is for testing purposes only and I want to do for a few

days before setting it to run on a daily basis.

Appreciate your advise/ recommendation.

Thank You.....