Explain Dimensional Modelling?
Submitted by: AdministratorDimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. 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 measuremnets ie, the dimensions on which the facts are calculated.
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. 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 measuremnets ie, the dimensions on which the facts are calculated.
Submitted by: Administrator
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. 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 measuremnets ie, the dimensions on which the facts are calculated.
Submitted by: Administrator
Read Online Data Warehousing Basics Job Interview Questions And Answers
Top Data Warehousing Basics Questions
| ☺ | Explain the definition of normalized and denormalized view and what are the differences between them? |
| ☺ | Explain degenerate dimension table? |
| ☺ | What is the main difference between schema in RDBMS and schemas in DataWarehouse? |
| ☺ | What are the Data Marts? |
| ☺ | Explain Differences between star and snowflake schemas? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
