What is a Fact Table?

Fact Table discussion. A fact table is the central table in a star schema of a data warehouse. A fact table stores quantitative information for analysis and is often deformalized. In data warehousing, a fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or a snowflake schema surrounded by dimension tables. … The Read More…