« previous next »

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

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

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.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Critical thinking involves analysis in which the nurse examines patient data available from a variet Critical thinking involves analysis in which the nurse examines patient data available from a variet
Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa Zonal wind speeds on Uranus. Shaded areas show the southern collar and its future northern counterpa
Cultures Ideal Body Types Cultures Ideal Body Types
Selective breeding of maze-bright and maze-dull strains of rats by Tryon (1934). (Data from Cooper, ... Selective breeding of maze-bright and maze-dull strains of rats by Tryon (1934). (Data from Cooper, ...
Distribution of Thunderstorms: Detailed data on cloud-to-ground lightning flashes have been ... Distribution of Thunderstorms: Detailed data on cloud-to-ground lightning flashes have been ...
Survivorship curves. Blue lines are theoretical curves. Red dots are data from field studies. Survivorship curves. Blue lines are theoretical curves. Red dots are data from field studies.
Video: Krebs cycle : Formation of acetyl coenzyme A and Electron transport chain

For a complete list of videos, visit our video library