Author Question: Explain the functions of a data warehouse. What will be an ideal ... (Read 164 times)

cagreen833 · **on:** Jul 7, 2018

Explain the functions of a data warehouse.

What will be an ideal response?

Question 2

Each task in a systems development project should culminate in one or more ________.

A) deliverables
B) zones
C) segments
D) designs

kiamars2010 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

The functions of a data warehouse are to:
1. Obtain data
2. Cleanse data
3. Organize and relate data
4. Catalog data
Programs read operational and other data and extract, clean, and prepare that data for business
intelligence processing. The prepared data are stored in a data warehouse database using a data
warehouse DBMS, which can be different from an organization's operational DBMS. Data
warehouses include data that are purchased from outside sources. Metadata concerning the
dataits source, its format, its assumptions and constraints, and other facts about the dataare
kept in a data warehouse metadata database. The data warehouse DBMS extracts and provides
data to BI applications.

Answer to Question 2

A