IT Employment

Ask something
Discussion Locked

dimensional model

0 helpful
4 replies

by mark_anderson2004

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What are dimensions and facts? How is data stored in facts?

4 replies

by haris

Dimensional modelling is a data modellng technique to facilitate data analysis (OLAP). A business is organised by subject areas that are shown as dimensions on this model. Fact table is the join among the dimension and contain the "facts" for the dimensions. For example, Sales dimension can read the total sales in a particular city using the fact table. OLAP is supported by building cubes. This modelling technique is mainly used in data warehousing.

This discussion is closed to new replies.