Relational Solutions Blog

Data Warehouse or Data Mart? What's the Difference

Posted by Janet Dorenkott on Mon, Aug 10, 2015 @ 05:05 PM

What’s the difference between a Data mart and a Data warehouse? Why are they so often confused.

Simply put, an enterprise data warehouse is the union of all marts being fed by a single source. That single source is a staging area where data is cleansed and harmonized and is often referred to as an ODS or Operational Data Store.

 A data mart can be stand alone reporting solution or it can be soundly integrated into an enterprise data warehouse.

READ MORE

Topics: data mart, data warehouse

SUBSCRIBE

    New Call-to-Action
    Shedule A Consultation

    LATEST POSTS