Data warehousing Dimensional Modeling: What is Dimensional Modeling?

What is Dimensional Modeling?

Dimensional modeling is often used in Data warehousing. In simpler words it is a rational or consistent design technique used to build a data warehouse. DM uses facts and dimensions of a warehouse for its design. A snow and star flake schema represent data modeling.

What is Dimensional Modeling?

Dimensional modeling is one of the logical design techniques used in data warehousing. It is different from entity-relationship model. If applied to relational databases, and done properly, it is 2nd or 3rd normal form. It does not necessarily involve relational database. The logical level of modeling approach can be applied in physical form like database tables or flat files. It is one of the techniques for the support of end-user queries in data warehousing. On contrary to database administration, it is oriented around understandability.
Data warehousing surrogate key: What is surrogate key? Explain it with an example.
What is surrogate key? - ETL is Extract Transform Load. It is a process of fetching data from different sources, converting the data into a consistent and clean.........
Data warehousing Factless Fact Table: What is the purpose of Factless Fact Table?
What is the purpose of Fact less Fact Table? - Fact less tables are so called because they simply contain keys which refer to the dimension tables..........
Data warehousing: What is a level of Granularity of a fact table?
What is a level of Granularity of a fact table? - A fact table is usually designed at a low level of Granularity. This means that we need to find the lowest level of information.......
Post your comment