> For the complete documentation index, see [llms.txt](https://gchandra.gitbook.io/data-warehousing/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gchandra.gitbook.io/data-warehousing/data-warehousing-concepts/dimensional-modelling/multi-fact-star-schema.md).

# Multi-Fact Star Schema

The schema with more than one fact table linked by normalized dimension tables is often called a "Data Mart Schema" or a "Multi-Fact Star Schema."

This schema can be helpful when you have multiple fact tables that share some but not all dimensions and where the dimensions are normalized.

* Multiple Fact Tables: For different aspects of the business.
* Normalized Dimension Tables: To avoid redundancy and improve data integrity.

It's a complex, real-world adaptation designed to meet specific business needs.