Dimensional Modeling is a design concept USED by many data warehouse designers to build their data warehouse. In this design model all the data is stored in TWO types of tables - Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measurements i.e., the DIMENSIONS on which the facts are calculated.Dimension modeling is a method for DESIGNING data warehouse. Three types of modeling are there

1. Conceptual modeling
2. LOGICAL modeling
3. Physical modeling.

Dimensional Modeling is a design concept used by many data warehouse designers to build their data warehouse. In this design model all the data is stored in two types of tables - Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measurements i.e., the dimensions on which the facts are calculated.Dimension modeling is a method for designing data warehouse. Three types of modeling are there

1. Conceptual modeling
2. Logical modeling
3. Physical modeling.