Better to Refresh or rebuild cubes -
05-02-2006
, 10:17 AM
I have a cube data.
Now everyday I get about 10-15% of data updates and new insert records into
its underlying tables from which the cubes are built from.
Now the question is, am I better off
1) Droping the cubes and rebuilding them or
2) Refreshing the existing data cubes
BTw, I have a schedule dts package that call an app to drop & rebuild the
cubes. I could also just add an Analysis dts package to refresh it.
Any ideas ? |