wht is degenerated dimension ?it's uses?
- 10 Answers
- 48858 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 the differences between normalizer and normalizer transformation?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is difference macros and prompts?
What is the difference between snowflake and star schema?
What is execution plan?
What is metadata in context of a datawarehouse and how it is important?
How to generate the cubes in framework manager?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is data mart in data warehouse?
What is surrogate key? Where we use it? Explain with examples.
What is surrogate key? Explain with examples.
What is the metadata extension?
What is type 2 version dimension?
Explain the difference between filter and conditin?
What is the purpose of Dataware Control?
