Difference between Data Warehouse and Data Mart

 

Data Warehouse

Data Mart

n      Enterprise-wide

n      Structure for corporate view of data

n      Organized E-R Model or Galaxy of Star (Multiple Star schemas in the Data Model)

n      Long turn around time

n      Departmental

n      Star Schema based (Facts and dimensions)

n      Quick turn around (up and running as there are less stakeholders)