Here the differences in a data warehouse and data mart.
It is one of the most important question as it is been asked in many exams as well as in viva exams
It is one of the most important question as it is been asked in many exams as well as in viva exams
Data Warehouse | Data Mart |
---|---|
1) It gives enterprise wide view of data. | 1) It gives departmental view of data. |
2) Union of all data marts. | 2) Subset of data warehouse or single business process. |
3) Takes longer time to implement. | 3) Takes less time to implement. |
4) Size is more than 100TB. | 4) Size is less than 10TB. |
5) Slower response. | 5) Faster response. |
6) Detailed Information. | 6) Summarized data. |
7) It is difficult to build. | 7) Is easy to build. |
8) Complex and difficult to manage. | 8) Easy to design and use/manage. |