wht is degenerated dimension ?it's uses?
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
What is the difference between agglomerative and divisive hierarchical clustering?
What are the steps involved in designing a fact table?
Is there any difference in testing database and data ware housing?
What is data warehouse architecture?
Explain what are the vaious etl tools in the market?
Explain what is batch and describe about types of batches?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is Active Datawarehousing?
How do you create surrogate key using ab initio?
What is the difference between olap and datawarehosue?
What does level of granularity of a fact table signify?
Can we start and stop single session in concurent bstch?
What is your spectra photometer working principles?
Explain what is the limit to the number of sources and targets you can have in a mapping?