Editing Data mart (section)

==Data mart vs data warehouse==
Data warehouse:
* Holds multiple subject areas
* Holds very detailed information
* Works to integrate all data sources
* Does not necessarily use a [[Dimensional modeling|dimensional model]] but feeds dimensional models.

Data mart:
* Often holds only one subject area- for example, Finance, or Sales
* May hold more summarized data (although it may hold full detail)
* Concentrates on [[information integration|integrating information]] from a given subject area or set of source systems
* Is built focused on a dimensional model using a star schema.