Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Describe the differences between a data warehouse and data mart ?

user-image
Question ajoutée par Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date de publication: 2015/01/09
Denny Luyis
par Denny Luyis , Teacher , TWP Translations Ltd

The biggest difference between a data mart and a data warehouse https://www.mighty.digital/blog/data-warehouse-vs-data-mart-know-the-difference is the amount of information they hold. A data mart holds smaller amounts of data than a data warehouse, while a data warehouse stores much larger datasets. Data marts also store a specific subject area. Knowing the difference between a data mart and a data warehouse can help you choose which is right for your company.

Ibrahim Hussein Mayaleh
par Ibrahim Hussein Mayaleh , Sales & Business Consultant and Trainer , Self-employed

Thank you for the invitation, but I know too little about this field

Vinod Jetley
par Vinod Jetley , Assistant General Manager , State Bank of India

Warehouse:

 

Holds multiple subject areas

Holds very detailed information

Works to integrate all data sources

Does not necessarily use a dimensional model but feeds dimensional models.

Data Mart

 

Often holds only one subject area- for example, Finance, or Sales

May hold more summarised data (although many hold full detail)

Concentrates on integrating information from a given subject area or set of source systems

Is built focused on a dimensional model using a star schema

More Questions Like This