What is Dimensional Model in Data Warehouse?

Sharad Jaiswal
Sharad Jaiswal

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Data Warehousing Interview Questions

    What are the fundamental elements of the data warehouse?

    A data warehouse consists of data which is obtained from data sources or in other words, external sources...

    Data Warehousing Interview Questions

    What is Data Analytics in simple terms?

    Data analytics or simply DA is the science used for examining raw data with the purpose of concluding that information. This is mostly built to enable the Data Analytics..