Datamart | Data Warehouse |
1.Data mart is usually sponsored at the department level and developed with a specific issue or subject in mind, a data mart is a data warehouse with a focused objective. | 1.Data warehouse is a “Subject-Oriented, Integrated, Time-Variant, Nonvolatile collection of data in support of decision making”. |
2.A data mart is used on a business division/ department level. | 2.A data warehouse is used on an enterprise level. |
3.A Data Mart is a subset of data from a Data Warehouse. Data Marts are built for specific user groups. | 3.A Data Warehouse is simply an integrated consolidation of data from a variety of sources that is specially designed to support strategic and tactical decision making. |
4.By providing decision makers with only a subset of data from the Data Warehouse, Privacy, Performance and Clarity Objectives can be attained. | 4.The main objective of Data Warehouse is to provide an integrated environment and coherent picture of the business at a point in time. |
1 comment:
We're excited to announce that our parent company, American Crafts, is starting its annual warehouse sale in Utah tomorrow. survival warehouse products
Post a Comment