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.datawarehouse/browse_thread/thread/8ee96870badac8be/c1fcb42e0ce71039?lnk=gst&q=update+Fact+table+#c1fcb42e0ce71039

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

Relevant Pages

  • [HPADM] Celular PCI Card
    ... I was just curious if anyone has heard of a cellular PCI card for HP9000 ... the office building that is in front of these warehouses ever falls down ... For whatever reason the phone company wired every thing through ...
    (HP-UX-Admin)
  • Re: Music 123?
    ... They're combining something like 3 warehouses and for some reason everything on their side is falling apart. ... Not making excuses for them, but this is out of the norm. ...
    (alt.guitar.beginner)