« previous next »

Author Question: How is a data warehouse different from a data mart? What will be an ideal ... (Read 90 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?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

The nitrogen cycle. Numbers represent fluxes as 1012 g N per year (data from Schlesinger 1991, after The nitrogen cycle. Numbers represent fluxes as 1012 g N per year (data from Schlesinger 1991, after
Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry. Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry.
Cross-sectional data showing that the amount of effort spent on personal health care increases with Cross-sectional data showing that the amount of effort spent on personal health care increases with
Electronic service information is available from aftermarket sources, such as All-Data and ... Electronic service information is available from aftermarket sources, such as All-Data and ...
How to calculate the mean for grouped data How to calculate the mean for grouped data
Hubbard’s Predication of Peak in U.S Oil Production with Actual Data Hubbard’s Predication of Peak in U.S Oil Production with Actual Data
Video: Stimulus (introduction)

For a complete list of videos, visit our video library