Period Based Incremental Refresh

[Maran_Rengasamy]

Hi Team,

Can anyone explain how to do period-based Incremental load based on the Ship_Date column(Date format. not timestamp)?

In our current ETl tool, we delete the last 3 months(Ship_Date) records from the Data Warehouse table and load the last 3 months' data from the source table. because there will be changes in the last month's data. So we refresh the data daily for the last 3 months based on Ship_Date.

How to achieve this in Incorta load?

Thanks

[Maran_Rengasamy]

Excellent!!! Thanks for your input🙏.  I think the alternative method will work for my case.