Explain degenerate dimension table?
Submitted by: AdministratorDegenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno
Degenerate dimensions are those without any attributes or measures
and they are included inside the fact table
Eg orderno
Submitted by: Administrator
Degenerate dimensions are those without any attributes or measures
and they are included inside the fact table
Eg orderno
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. |