210k views
2 votes
A relational database contains information in a series of two-dimensional tables. how is data contained in a data warehouse and data mart?

User Neofetter
by
5.9k points

1 Answer

1 vote

In Data Mart it holds only single subject area, it is built for a dimensional model using a star schema. It focus on integrating information from a given subject area or set of source systems. While Data Warehouse holds many subject areas and a very detailed information it works to integrate all data sources, does not necessarily use a dimensional model but feeds dimensional models.

User Seva Kalashnikov
by
6.4k points