Data warehouse is non- updatable

Answer 1

The intention is: data in data warehouse is non updatable

But there exist some exceptions of the non-update rule which may be allowed by data warehouse organisation. Such cases may be:

- error correction of wrong data

- enhancement of missing data

- restructuring (parts of) data warehouse data(base) design

- ...

One leading idea beyond data warehousing resp. one purpose of data warehousing is to enable controller and other users to observe resp. monitor time variant data (e.g. revenue of a product during the last 24 months). It depends on the quality standards whether the above listed exceptions are allowed or not.

Answer 2

A data warehouse is a non-updatable, time-variant, integrated, and subject-oriented collection of data used to support decision-making management processes and business intelligence. The data warehouse is more than just a collection of an organization's operational databases.

To learn more about data science please visit- Learnbay.co