Updating data in a data warehouse

I found this thread about whether to update fact tables in data
warehouses, other than for errors in the data.

http://groups.google.com/group/microsoft.public.sqlserver.datawarehous...rowse_t

The thread was from 2003, so I thought I would start this one.

It seems to me that the reason you wouldn't update data in a data
warehouse is that each row represents an event, and if the data has to
be updated later on to reflect something that was unknown when the
record was created, it was probably because a new event has occured to
create the piece of data.

Any thoughts?

"Joe" wrote in message

>I found this thread about whether to update fact tables in data
> warehouses, other than for errors in the data.
>
> http://groups.google.com/group/microsoft.public.sqlserver.datawarehous...rowse_t
>
> The thread was from 2003, so I thought I would start this one.
>
> It seems to me that the reason you wouldn't update data in a data
> warehouse is that each row represents an event, and if the data has to
> be updated later on to reflect something that was unknown when the
> record was created, it was probably because a new event has occured to
> create the piece of data.
>
> Any thoughts?

If an update is needed to produce some correct and useful result then do the
update. Unless you have some specific data model or universe of discourse in
mind I don't see any other basis for saying whether an update is appropriate
or not.

--
David Portas