This topic contains a solution. Click here to go to the answer

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

cagreen833

  • Hero Member
  • *****
  • Posts: 544
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

kiamars2010

  • Sr. Member
  • ****
  • Posts: 341
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




cagreen833

  • Member
  • Posts: 544
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)


tuate

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

For a complete list of videos, visit our video library