ABSTRACT

In data warehousing, a fact table consists of the measurements, metrics, or facts of a business process. It is often located at the center of a star schema or a snowflake schema, surrounded by dimension tables. 8 In a dimensional database, a fact table is used to store measures of business activity, which are quantitative or factual data about the entity represented by the fact table. 171