Settled Data is Best for the Data Warehouse

Good advice...

Settled Data is Best for the Data Warehouse: "There is an accepted belief in the market that data needs to be as current as possible in the data warehouse. The advocates of that belief certainly are entitled to their opinion and have been extremely vocal about it.

There is, however, another view that does not advocate that all data in a data warehouse needs to be current. This view holds that a transaction that is executed in the operational environment should remain in the operational environment for at least 24 hours to a month. After that amount of time, the transaction should then be moved to the data warehouse.

There is a very good reason for this �delay� or �hiccup� of time. "