I have genereal question - is the incremental update much faster than
refresh data? How much?

Lets say I have a cube where fact table has one milion records, I also
have 3 dimensions 5 thousands records each. There is few thousands new
records in fact table each day nad I'm reprocessing cube daily. Which
aproach should I use?



Thanks for any hints.

Bartlomiej Bojko


--
Posted via http://dbforums.com

Incremental is faster than referesh.
You can use both because cube is small.
If you don't update records (only add) incremental is the best.
If you update records you should refresh

--
Jose Mariano Alvarez
Comunidad de base de datos
Grupo de Usuarios Microsoft
www.mug.org.ar



"b_bojko" <member37234 (AT) dbforums (DOT) com> wrote