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 189 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
Wow, this really help


amynguyen1221

  • Member
  • Posts: 355
Reply 3 on: Yesterday
Gracias!

 

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

For a complete list of videos, visit our video library