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 166 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
Gracias!


Chelseyj.hasty

  • Member
  • Posts: 319
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

For a complete list of videos, visit our video library