Data mart overview

A data mart is a simple form of a data warehouse that is focused on a single subject (or functional area), such as Sales, Finance, or Marketing.

The data mart contains data specific to a particular business area and is usually designed to satisfy the information requirements of a limited audience of users. DWD can manage any number of data marts each populated by one or more compiled DWD solutions.

A data mart is typically a star schema. Star schema

A data warehouse is defined as the physical data structure of all data marts. In small DWD installations the entire data warehouse could be located in one physical database. In a still smaller DWD installation, one specialized data mart might constitute the entire data warehouse.