How does InfoCube deletion mode affect loading performance?
we have a scenario where it is necessary to regularly delete the cube before loading.
As we have 2 options for deleting: with or without dimension-tables: what is the more performant way in order to avoid extensive sid-ding the next time the infocube is been loaded?
Normally, I'd expect the variant with only the fact-table to be more efficient as dims are already generated..
But what^s about the "unused" data: it will remain in the dimension-tables then for every time?
And apart from that: if the dimensions are not buffered, will the option "only fact table" really be an advantage?
So, where should the decision be based on?