Explain the term integrated in the following data warehouse ...

[oliviahorn72]

Explain the term integrated in the following data warehouse definition:The data warehouse is a structured repository of integrated, subject-oriented, enterprise-wide, historical, and time-variant data.
 
  The purpose of the data warehouse is the retrieval of analytical information. A data warehouse can store detailed and/or summarized data.

Question 2

In a supply chain, ________ are either production sites or warehouses.
 
  A) networks
  B) suppliers
  C) facilities
  D) components

[Anton]

Answer to Question 1

The idea behind a data warehouse is to create a repository of analytical information in the organization. This repository is physically separate from the existing operational databases in the organization. The data warehouse integrates the analytically useful data from those various operational databases. Integration refers to the process of bringing the data from multiple operational databases into a single data warehouse. Of course, in this process, no data is actually removed from the operational sources. Instead, the analytically useful data from various operational databases is copied and brought into the data warehouse.

Answer to Question 2

C

[oliviahorn72]

TYSM

[nathang24]

Thanks for the timely response, appreciate it