wht is degenerated dimension ?it's uses?
- 10 Answers
- 48774 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
Answer Posted / kvchowdary
degenerate dimension is a data dimension that is stored in
the fact table rather than a separate dimension table. This
eliminates the need to join to a dimension table. You can
use the data in the degenerate dimension to limit or 'slice
and dice' your fact table measure
| Is This Answer Correct ? | 13 Yes | 7 No |
Post New Answer View All Answers
Explain piconet?
What are the steps involved in designing a fact table?
What are the steps of implementing data warehousing?
Tell me what is degree of a relation?
Explain the definition of normalized and denormalized view?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Can a dimension table contain numeric values?
how much memory space occupied real time project (roughly)?
What are the methodologies of data warehousing?
Difference between PowerPlay transformer and power play reports?
Explain what is data validation strategies for data mart validation after loading process?
What is cost benefit analysis (cba)?
In microstrategy, how can we direct the sql generated to use a specifc table?
Explain what are the tasks that loadmanger process will do?
Where the applications and where ware house management system is used?
