Forum Discussion
Don-Bot
Helper V
2 years agoIncremental Refresh adding a new column to table
I have an extremely large table that is currently being updated via Incremental Refresh. I need to add a couple of fields to this main table. Is there a way I can use ALM Toolkit or XMLA Endpoi...
- 2 years ago
yes, and yes. Use ALM Toolkit to push the meta data changes WITHOUT recompute, and then use your favorite XMLA tool to slowly (!) reprocess all partitions (in "full" mode)
Obligatory note: If you have dependencies like auto data time then related partitions will be refreshed too.
lbendlin
Super User
2 years agoyes, and yes. Use ALM Toolkit to push the meta data changes WITHOUT recompute, and then use your favorite XMLA tool to slowly (!) reprocess all partitions (in "full" mode)
Obligatory note: If you have dependencies like auto data time then related partitions will be refreshed too.
- Don-Bot2 years ago
Helper V
Thank you! I'll test this on a smaller partition but awesome and thanks!