Incremental load with date and time field

[vireshkolagimat]

Hi All,

I've sample data like attached image. The combined key (ShLocation+ShInvNo+ShInvDate) act as primary key.

To identify the last modified date, I am using ShlastSyncDate column which contains the time part as well.

If i only consider date part while doing the incremental reload then i will miss some transactions. how to deal in this case. can we convert the date into num or something to avoid loss of data.

Kindly provide some suggestions.

Thank you.

Regards,

Viresh

[isingh30]

Did you try floor function with date? It will give you only data & not time.

Can you share data in excel file?

Thanks.

[vireshkolagimat]

Hi, yeah i got if i use the floor function, i can get rid of time part.

But i would like consider time part as well while doing the incremental load.

Please find the attached sample data.

Regards,

Viresh

[isingh30]

Try like this - num(shInvDate) as Date. This will convert the date into num.

Thanks.