What are the types of dimensional modeling in data warehouses?

1.	What are the types of dimensional modeling in data warehouses?
Answer» In Data warehouses, there are THREE types of DIMENSIONAL modeling: CONCEPTUAL Modeling Physical Modeling Logical Modeling 10. What is bus architecture in the data WAREHOUSE? In the data warehouse, bus architecture is made up of the set of tightly combined data marts that gets their potential from fact tables and conformed dimensions. Where, 1. Conformed dimensions it is defined and IMPLEMENTED only once so that it is meant to be the same thing wherever it is being used. 2. Fact Tables: which are conformed includes the things that derive revenue, profit, standard costs, and standard price.

Answer»

In Data warehouses, there are THREE types of DIMENSIONAL modeling:

CONCEPTUAL Modeling
Physical Modeling
Logical Modeling

10. What is bus architecture in the data WAREHOUSE?

In the data warehouse, bus architecture is made up of the set of tightly combined data marts that gets their potential from fact tables and conformed dimensions.
Where,

1. Conformed dimensions

it is defined and IMPLEMENTED only once so that it is meant to be the same thing wherever it is being used.

2. Fact Tables:

which are conformed includes the things that derive revenue, profit, standard costs, and standard price.

Discussion

No Comment Found

Related InterviewSolutions

What is the difference between ER Modelling vs Dimensional Modelling?
What is a real-time data warehouse and what are its benefits?
What is the snowflake schema in the data warehouse?
What are the types of dimensional modeling in data warehouses?
What are the main differences between structured and unstructured data?
What are the steps to build the data warehouse?
Would you like to tell us the difference between Data Warehousing and Data Mining?
What is the difference between various types of data warehousing?
What is data modeling in the data warehouse?
Why do we need a data warehouse instead of a database?