Data warehouse contains ______ data that is never found in operational environment.

Data warehousing:

It is a phenomenon that grew from huge amount of electronic data stored in recent years and from the urgent need to use that data to accomplish goals that go beyond the routine tasks linked to daily processing. Data warehousing is used in various applications such as: Trade, craftsmanship, financial services, transport industry, telecommunication etc.

Data warehouse architecture contains following points:

• Source system
• Source data transport layer
• Data quality control and profiling layer
• Metadata management layer
• Data integration layer
• Data processing layer
• End user reporting layer

Developing a data warehouse is no different from any other project. It requires complete planning, requirements, design, implementation. Data warehouse contains summary data that is not found in operational environment. Developing strategy of data warehouse is to establish virtual data warehouse. It is simply to build a copy of operational data from a single operational system and enable the data warehouse from a series of information access tools.

Diagram: