Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52166 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
Answer Posted / santosh
According to Ralph Kimbal, in a data warehouse, a degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table. Degenerate dimensions are often used when a fact table's grain represents transactional level data and one wishes to maintain system specific identifiers such as order numbers, invoice numbers and the like without forcing their inclusion in their own dimension. The decision to use degenerate dimensions is often based on the desire to provide a direct reference back to a transactional system without the overhead of maintaining a separate dimension table.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
What is the use of dimensional modeling in data warehousing?
What is a full backup?
What are the types of dimensional modeling?
Can decision tree be implemented using SQL?
Who needs data warehousing?
Store (and count) non-fact records?
Explain what are the possible data marts in retail sales?
What is execution plan?
Can we have multiple application.cfm file in an application?
What are fact, dimension, and measure?
Explain why dimenstion tables are denormalized in nature?
Explain which are the olap tools available that are supported by oracle?
what is difference between drill & scope of analysis?
What are loops in Datawarehousing?
Compare cold fusion with other programming languages?
