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
Three types of modeling are there
1. Conceptual modeling
2. Logical modeling
3. Physical modeling
No comments:
Post a Comment