« previous next »

Author Question: How is a data warehouse different from a data mart? What will be an ideal ... (Read 89 times)

robinn137

  • Hero Member
  • *****
  • Posts: 544
on: Jul 7, 2018
How is a data warehouse different from a data mart?
 
  What will be an ideal response?

Question 2

________ decisions are those that support day-to-day activities, such as the number of widgets to order from a particular vendor.
 
  A) Managerial
  B) Tactical
  C) Strategic
  D) Operational


mcni194

  • Sr. Member
  • ****
  • Posts: 311
Reply #1 on: Jul 7, 2018
Answer to Question 1

A data warehouse can be compared to a distributor in a supply chain. The data warehouse takes data from the data manufacturers (operational systems and other sources), cleans and processes the data, and locates the data on the shelves of the data warehouse. The data analysts who work with a data warehouse are experts at data management, data cleaning, data transformation, data relationships, and the like. The data warehouse then distributes the data to data marts.
A data mart is a data collection, smaller than the data warehouse that addresses the needs of a particular department or functional area of the business. If a data warehouse is the distributor in a supply chain, then a data mart is like a retail store in a supply chain. Users in a data mart obtain data that pertain to a particular business function from a data warehouse. Such users do not have the data management expertise that data warehouse employees have, but they are knowledgeable analysts for a given business function.

Answer to Question 2

D


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

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?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Extent of agricultural activity across the planet (data from Foley et al. 2005). Extent of agricultural activity across the planet (data from Foley et al. 2005).
Summary of US Census Data Summary of US Census Data
Cultures Ideal Body Types Cultures Ideal Body Types
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Histograms - Analysis and Data Histograms - Analysis and Data
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Video: Conduction of action potentials

For a complete list of videos, visit our video library