Difference between Datamarts and Data warehouse

Datamart Data Warehouse
1.Data mart is usually sponsored at the department level and developed with a specific issue or subject in mind, a data mart is a data warehouse with a focused objective. 1.Data warehouse is a “Subject-Oriented, Integrated, Time-Variant, Nonvolatile collection of data in support of decision making”.
2.A data mart is used on a business division/ department level. 2.A data warehouse is used on an enterprise level.
3.A Data Mart is a subset of data from a Data Warehouse. Data Marts are built for specific user groups. 3.A Data Warehouse is simply an integrated consolidation of data from a variety of sources that is specially designed to support strategic and tactical decision making.
4.By providing decision makers with only a subset of data from the Data Warehouse, Privacy, Performance and Clarity Objectives can be attained. 4.The main objective of Data Warehouse is to provide an integrated environment and coherent picture of the business at a point in time.

Reactions:
 
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response.
1 Response
  1. Asoka Packers and Movers Hyderabad is the most consistently ranked packers and Movers Company and has delivered over 56,000 homes all over India
    Packers and Movers Bangalore
    Packers and Movers Pune
    Packers and Movers Delhi
    Packers and Movers Gurgaon

Leave a Reply

Recent Comments