wht is degenerated dimension ?it's uses?
Answer Posted / krishna murari
These are some date elements in the operational system
which are neither fact nor strictly dimension attributes.
These are useful for some kind of analysis.
These are kepts as attributes in fact table called
degenerated dimension
| Is This Answer Correct ? | 21 Yes | 12 No |
Post New Answer View All Answers
Explain what are the methodologies of data warehousing?
Explain the hierarchies level data warehousing.
Explain what are the various transformation available?
Explain what is the data type of the surrogate key?
In microstrategy, how can we direct the sql generated to use a specifc table?
What is the difference between ods and oltp?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is metadata in context of a datawarehouse and how it is important?
Explain what is the difference between view filter and report filter?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What are the advantages of query studio compared to report studio?
What is degenerate dimension table?
How to pivot data using informatica when you have variable amount of pivot rows?
What are the main steps to build the data warehouse?
Define Data Warehousing?