asked 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?

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.

Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.