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.