« previous next »

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

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Model of a longitudinal study in which 983 students were surveyed in 1984 and then again in 1985, 19 Model of a longitudinal study in which 983 students were surveyed in 1984 and then again in 1985, 19
Prevalence of Diabetes in the United States Based on Age and Sex Data from the American Diabetes ... Prevalence of Diabetes in the United States Based on Age and Sex Data from the American Diabetes ...
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Flow cytometry data that shows the differences in CD3+ CD4+ cells that occur with HIV infection. ... Flow cytometry data that shows the differences in CD3+ CD4+ cells that occur with HIV infection. ...
A model of the 70S ribosome based upon early structural data A model of the 70S ribosome based upon early structural data
data data
Video: A timeline of the teeth (Explained - No Audio)

For a complete list of videos, visit our video library