Skip to Content
avatar image
Former Member

Generic Datasource Delta

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Oct 19, 2015 at 02:36 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 12:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 01:17 PM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 01:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 04:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded