Dimensional modeling contributes to being the data structure process which is optimized for data warehousing tools. Ralph Kimball came up with the concept of dimensional modeling. The dimensional modeling primarily contains dimensional table and the fact table. A dimensional model is beneficial for summarizing, reading and analysis of numeric details such as balances, values, weights, and counts in the data warehouse. Relation models, on the other hand, are optimized for updating, addition as well as removal of data in real time online transaction system.
© Copyright Data Warehouse Solutions