We help IT Professionals succeed at work.

DW Vs DM

anushahanna
anushahanna asked
on
What is the technical diff between Data warehouse and data mart?
Comment
Watch Question

Read this...good article
http://www.information-management.com/infodirect/19991120/1675-1.html
http://www.exforsys.com/tutorials/data-warehousing/the-difference-between-data-mart-and-data-warehouse.html

Open in new window

Top Expert 2011
Commented:
basically a data warehouse store the business data in a format that will allow the business to query it for Business intelligence/Data Mininf / Management Information reports.. It will be fed with information obtained from the business transactional processing systems , and other sources.

The data will be held so that detailed time frame analysis of the data will eventually be possible be the owning business departments.

A Data Mart is an extract of data from the Data Warehouse which has been further processed to allow the business to answer particular questions relating to a specific
area of the business, or in a specific manner.

The data extract could be just a one for one extract from the data warehouse , done primarily for efficentcy and availabilty reasons, or could be a more complex re-mapping of the data to suite the actual requirements of the business in a certain sector.

 
i

Author

Commented:
Thanks very much for the clear differences.