Incremental Load

[Anonymous]

Hi

I have following sales data going back to year 2014.  The actual model i have takes an hour to reload as it reloads all the data.  I want to reduce the reload time by applying incremental reload.  How do i accomplish this.  Basically, the incremental reload should be the last sales date.

Attached herewith is the data.

Kind regards

Nayan

[its_anandrjs]

When you load data by this statement Where Date > '$(vMaxDate)'; this will read only max records based on the available data if it is few rows and abusively there are few rows then it will take less time to load.