What is Dimensional Model in Data Warehouse?

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.