Describe dimensional Modeling.Dimensional model is a method in which the data is stored in two types of tables namely facts table and dimension table. Fact table comprises of information to measure business successes and the dimension table comprises of information on which the business success is calculated. It is mainly used by data warehouse designers to build data warehouses. It represents the data in a standard and sequential manner that triggers for high performance access.
Describe dimensional Modeling.Dimensional modeling is a design concept which is used by designers of building data warehouses. The data is stored in two types of tables - fact table and dimension table. Facts or measurements of the business are persisted in fact table and the context of measurements such as the dimensions on which the calculation of facts takes place.