Forum Discussion

audslloyd43's avatar
audslloyd43
Frequent Visitor
6 years ago

Setting up incremental refresh

Hi We have a query to help with forecasting which now has 10 million rows at source and taking forever to refresh.  I want to set up incremental refresh to only load the last month.  Previous year...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

No. The first refresh after you make structural changes will always be a full refresh (unless you use ALM Toolkit).

 

On the desktop you can artificially narrow the RangeStart and RangeEnd parameter default values to only work on a subset of the data.  Then in the incremental refresh setup you can specify how you actually want it to be partitioned.