Generic data source with Long form of Timestamp as generic delta field

[former_member594685]

Hello,

We have a requirement to build generic extractor and pull delta based on time stamp field already available in table.

This timestamp field is "Long form of timestamp" YYYYMMDDhhmmss,mmmuuun. Will this field work as generic delta field?

What should we put in safety interval? For YYYYMMDDhhmmss, we put it in seconds but in this case we have resolution up to nano seconds.

I have worked on generic delta but there we had YYYYMMDDhhmmss format of timestamp.

Please let me know your thoughts.

[former_member594685]

This is very urgent for us. Can anybody help me with this?

[sdsunny372]

Hi Viral,

sorry for late ,but i have just joined before few days back.

There are 2 formats for Timestamp fields:-

DEC 21 - (YYYYMMDDhhmmss,mmmuuun)

DEC 15 - (YYYYMMDDhhmmss)

if you have DEC 15 in your table, then use Timpstamp (local),

else if it is DEC 21 then use Timestampe(UTC) while defining the Generic Delta for your datasource and keep safety interval upper limit 1800 ( or as per your requirement).

Best Regards,

Sagarkumar Darji