What is degenerate dimension table?
Submitted by: AdministratorDegenerate Dimensions: If a table contains the values, which r neither dimension nor measures is called degenerate dimensions. For example invoice id, employee no.A degenerate dimension is data that is dimensional in nature but stored in a fact table.
Submitted by: Administrator
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
| ☺ | What is the difference between aggregate table and materialized view? |
| ☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
| ☺ | What is the advantages data mining over traditional approaches? |
| ☺ | What are data validation strategies for data mart validation after loading process? |
| ☺ | Can you pass sql queries in filter transformation? |
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. |
