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.
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.
