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