A typical example is to compare a logical business to a cube. The product dimension, time dimension, and location dimension are different coordinate axes, and the intersection of coordinate axes is a detailed fact. That is to say, a fact table is an intersection of multiple dimension tables. A dimension table is a form for analyzing facts.
First, we will introduce the star structure in the database structure. This structure maintains data in a single fact data table located in the structure center. Other dimension data is stored in the dimension table. Each dimension table is directly related to a fact data table and is usually linked to a fact data table by a single key. The star architecture is a structure in which the data warehouse flows more than the shard.
A fact table is a central table in the data warehouse structure. It contains the numerical metric values and keys that relate to the fact and dimension table. Fact data tables include data describing specific events in a business (such as product sales.
A dimension table is a set of dimension attributes. Is a form for analyzing the problem. It is a specific point of view for people to observe data. It is a type of attribute in consideration of the problem. The set of attributes forms a dimension.
Definitions of fact tables and dimension tables in Bi