Certainly, when a warehouse is designed to only contain a representation of
wha'ts in the sources at the extraction time or history is maintained as
point in time copies (month ends is a typical example)

Under these conditons, many times a truncate and bulk copy process is faster
than an incremental update. However, this technique will lose ground time
wise as data grows where an incremental process generally doesn't grow much.

Ray

"SG" <sgpgpjr@yahoo.ie> wrote in message
news:fe3ac5dd.0501110346.70e3325b@posting.google.c om...
> Hi,
> Is there ever a case where a total rebuilt is preferable to an
> update? I am talking in the context of a data warehouse.
>
> Many thanks
> Sam