DATAMART |
DATA WAREHOUSE |
| A scaled - down version of the Data Warehouse that addresses only one subject like Sales Department, HR Department etc., |
It is a database management system that facilitates on-line analytical processing by allowing the data to be viewed in different dimensions or perspectives to provide business intelligence. |
| One fact table with multiple dimension tables. |
More than one fact table and multiple dimension tables. |
| [Sales Department] [HR Department] [Manufacturing Department] |
[Sales Department , HR Department , Manufacturing Department] |
| Small Organizations prefer DATAMART |
Bigger Organization prefer DATA WAREHOUSE |
