dbTalk Databases Forums  

Better to Refresh or rebuild cubes

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Better to Refresh or rebuild cubes in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Acie
 
Posts: n/a

Default 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 ?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.