Delta field in Generic data source?

[Former Member]

Hi,

i have a scenario here. i need to enable delta for generic data source. from source i am getting Create date and change date.

now by using which field i can make the delta to bring correct records?

Thanks

[RamanKorrapati · Accepted solution]

Hi,

Use delta method as Time stamp and field is Changed date.

By using time stamp delta we can run delta info pack N number of times if business needs.

Changed date will track the all changed history.

Thanks

[former_member182516]

Hi Sudha,

Change dt - You use this as delta to extract only the changes

Create dt - this can be used to extract the newly created documents.

If you want delta data source -- create 2 generic delta data sources.

delta 1: based on Create Date

delta 2: based on Change Date

RSO2 --> Generic delta --> select "Calend. Day" radio button --> enter Create Date and similarly enter Change date for the other data source.

Time stamp - The field is a DEC15 field which always contains the time stamp of the last change to a record in the local time format.

Time stamp - this is combination of "date & time".

In your case as your data source have only date fields you can't use the timestamp field for delta.

Regards

KP

[arivazhagan_sivasamy]

Hi Sudha,

Please use change date.

If you create doc today, you may modify the the records some other day.

Arivazhagan S

[Former Member]

Hi,

if i put the change date what about the today records?

what i mean if i give change date it will get the changed records which are created already but what about the records which i am going to create? by using which field it will identify for newly created fields?

[RamanKorrapati]

Hi,

for new record also it show changed(create) as today only.

anyway your doing at dev system, choose changed date and try to load delta data. it will clear your doubts .

Thanks

[arivazhagan_sivasamy]

Hi Sudha,

While creating record you must fill the change date also.

While creating create date should be equal to change date and changing, create date may not be equal to change date.

Arivazhagan S