Facts are the measurements/metrics or facts from your business process. For a Sales business process, a measurement would be quarterly sales number
Dimension provides the context surrounding a business process event. In simple terms, they give who, what, where of a fact. In the Sales business process, for the fact quarterly sales number, dimensions would be
In other words, a dimension is a window to view information in the facts.
The Attributes are the various characteristics of the dimension in dimensional data modeling.
In the Location dimension, the attributes can be
Attributes are used to search, filter, or classify facts. Dimension Tables contain Attributes
A fact table is a primary table in dimension modelling.
A Fact Table contains