« previous next »

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

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Summary of US Census Data Summary of US Census Data
Data from more than 22,000 men over the age of 40, showing the relationship between birth weight and ... Data from more than 22,000 men over the age of 40, showing the relationship between birth weight and ...
Looking carefully at the scan tool data is very helpful in locating the source of a problem. Looking carefully at the scan tool data is very helpful in locating the source of a problem.
Design Data for Various Packings Design Data for Various Packings
A hypothetical grid of data used in synteny testing A hypothetical grid of data used in synteny testing
Ribosome structure and tRNA-binding sites interpreted from cryo-EM–generated data Ribosome structure and tRNA-binding sites interpreted from cryo-EM–generated data
Video: Regulation of GFR: autoregulation via tubuloglomerular feedback, neural & hormonal regulation

For a complete list of videos, visit our video library