Posted On: Feb 22, 2018
A dimensional model is a model that is developed to read numeric information, summarise the information and analyzing it. This numeric information includes counts, balance, and weight in a warehouse. This model is a data structure technique made to function more efficiently for Data warehousing tools. A man known as Ralph Kimball is responsible for the development of the concept of Dimensional Modelling. The dimension modeling is made up of dimension and fact tables. On the other hand, relational models focus on adding, deleting and updating in an online transfer system (real-time). The dimensional and relation models are both used in any system involved in the data warehouse.
Never Miss an Articles from us.
A data warehouse consists of data which is obtained from data sources or in other words, external sources...