Skip to Content
0
Former Member
Sep 14, 2007 at 10:56 AM

URGENT: Generic DS with delta extraction

19 Views

Hi experts,

I would need from your help. I need to create one Generic DS with delta extraction, based on timestamp so we can keep track of changes, deletions and new records added to our Z table.

I've been reading some different posts and "how to" docs, but besides creating the generic DS, selecting the Generic Delta button and choosing timeStamp option, many questions arise to me:

- In my table we have a "Created on" and "Modified" date fields included. New records do only have Created on and only once they are modified, they get the modified date informed.

- Initially, once a record is deleted, it's removed form the table (keeping the original entry with a status field is not desired by the customer).

Based on these facts, how should I create my generic DS? Selecting Timestamp based on "Modified date"? Create date? My feeling is that each option would only track in my delta queue whether changed or new records, never both.

What about deletions?

In case so, what is the solution to meet all three requirements (track new, modified, deleted records)? FM extraction?

Please provide assistance as soon as possible.

Thanks in advance!