wht is degenerated dimension ?it's uses?
- 10 Answers
- 48945 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
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is crass reference table?
How to pivot data using informatica when you have variable amount of pivot rows?
Do you view contain data?
Explain me what are conformed dimensions?
Explain how to get the first 100 rows from the flat file into the target?
What are the different types of scd's used in data warehousing?
How to provide security in frame work manager for a query subject?
What is factless fact tables?
What are the key features of chameleon that separates it from other algorithms?
What is a data profile?
What is a fact, dimension, measure?
Explain datawarehousing?
Ist the schema that a data warehouse system can implements.
How can you set the session management?
