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) |