Saved Bookmarks
| 1. |
What Is Dimensional Modelling? |
|
Answer» Dimensional MODELLING 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. Dimensional Modelling 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. |
|