Data Mart is subset of Data Warehouse usually oriented to
a specific business line or subject area. In an organization we may have
reporting needs around different subjects areas- like Sales, Finance, HR,
Procurement, Technology etc….And we may have Data Marts for each of them……each
of these data marts may have separate respective owners, separate hardware and
software. And those owners or respective business analysts and users can make
the changes, do the development, and make manipulations as per their own
requirements without stepping into other’s territory/Data Marts.
Data Mart is more focused version of Data Warehouse.
Whereas Data Warehouse is Enterprise wide
data.
