0
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.
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
Add your answer:
Earn +20 pts
When was The Carphone Warehouse created?
The Carphone Warehouse was created in 1989.
When was Bunnings Warehouse created?
Bunnings Warehouse was created in 1952.
What advantage does an entity bean have over a session bean?
An entity bean represents non-persistent data.
What is public ware house?
Public Warehouse is when an independant warehouse company that arranges to stores and controls finacing and inventory collateral for public warehouses.
Where can you watch warehouse 13?
Amazon video has this for viewing.
What is data where housing and mining?
it's data warehouse....data warehouse: it is a collection of multiple databases or it it is repository of data.data mining it is the process of extracting data from data warehouse.
Are Minecraft mods updatable?
Yes, most Minecraft Mods are updatable.
What do you mean by data warehouse?
Data warehouse is a house where current as well as historical data can be stored.
What are the key relationships between data warehouse and data mining?
Data warehouse is the database on which we apply data mining.
How does Data Warehouse differ from Data Mart?
Data marts are combined into a data warehouse cannot be built alone without considering data marts. Both has equal importance to built proper data warehouse.
What is metadata what is its use in data warehouse architecture?
Metadata is data about data that provides information such as the structure, format, and characteristics of the data stored in a data warehouse. It is used in data warehouse architecture to facilitate data integration, data governance, and data lineage. Metadata helps users understand and manage the data in the data warehouse efficiently.
Every data structure in data warehouse contains time element?
Every data structure in the data warehouse contains the time element. Why?
What is the difference between data warehouse testing and conventional testing?
ETL stands for Extract-Transform-Load and it is a process of how data is loaded from the source system to the data warehouse. Data is extracted from an OLTP database, transformed to match the data warehouse schema and loaded into the data warehouse database.Many data warehouses also incorporate data from non-OLTP systems such as text files, legacy systems and spreadsheets. Conventional testing is a sort of testing in which the test engineers will check the developed application or its related parts are working accordingly to the expectations of customer or not, from coding phase of SDLC to the end
What are benefits of data warehouse?
One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.
What makes the best data warehouse architecture?
A data warehouse architecture is similar to various relational database systems. What makes the best architecture is the organization of the warehouse itself and the data it consist of.
What are the advantages of a warehouse?
Data warehouse is the pool of huge amount of data. The data in data ware house can be archived. And when the data is needed you can extract it from the archived files.
What is distributed data warehouse?
A distributed data warehouse is a type of data warehouse architecture where data is distributed across multiple servers or nodes in a network. This allows for improved scalability, performance, and fault tolerance compared to a centralized data warehouse. Distributed data warehouses can handle large volumes of data more efficiently by spreading the workload across multiple nodes.
