Differences Between Data Warehouse and Data Mart
Key Differences Between Data Warehouse and Data Mart 1. Data warehouse is application-independent whereas data mart is specific to decision support system application. 2. The data is stored in a single, centralized repository in a data warehouse. As against, data mart stores data decentrally in the user area. 3. Data warehouse contains a detailed form of data. In contrast, a data mart contains summarized and selected data. 4. The data in a data warehouse is slightly denormalized while in the case of Datamart it is highly denormalized. 5. The construction of a data warehouse involves a top-down approach. Conversely, while constructing a data mart the bottom-up approach is used. 6. Data warehouse is flexible , information-oriented, and longtime e...