Generic Datasource Delta

[Former Member]

Hi All,

Is it possible to have a delta for a Generic Datasource where the extract structure has no date/time field ?

I do see a numeric pointer for the delta but not sure on how it will work in such a scenario .

[KodandaPani_KV · Accepted solution]

Hi,

Numeric point will work only new records not for the changed records.

if choose the options calday or timestamp it will capture the all the information (changed/new)

Thanks,

Phani.

[former_member183519]

Hello Naresh,

Generic Delta extraction is based on 0calday, Timestamp & Numeric Pointer.

   When to use Numeric Pointer ??

->We used numeric pointer in the case where detla always monotonically in increasing order like      Sales    order Number, Customer, PO Number etc. .

+ If data is critical then in addition to this we can set safety limit to avoid loss of data.

Regards,

Hitesh

[anil_babu13]

Numeric pointer works if you are getting only new records not changed records as far as i know. check with functional people if there are any possibilities to include relevant field date/time field in the generic datasource tables to identify delta and proceed accordingly.

regrds,

anil

[Former Member]

Hi,

The numeric pointer will work if each new record has a new number (incremental) in the field selected for numeric pointer.

[Former Member]

Hi,

It is possible to create a Generic Data source where the extract structure has no date/time field for Delta functionality. As you said you need to use Numeric Pointer in this case. For example if you created Numeric Pointer on Number of Customer , when ever you create a New Customer it will save it as a Delta Record.