Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52422 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
Answer Posted / takhatraj singh chouhan
Degenerated Dimension is a dimension key without corresponding dimension. Example:
In the PointOfSale Transaction Fact table, we have:
Date Key (FK), Product Key (FK), Store Key (FK), Promotion Key (FP), and POS Transaction Number
Date Dimension corresponds to Date Key, Production Dimension corresponds to Production Key. In a traditional parent-child database, POS Transactional Number would be the key to the transaction header record that contains all the info valid for the transaction as a whole, such as the transaction date and store identifier. But in this dimensional model, we have already extracted this info into other dimension. Therefore, POS Transaction Number looks like a dimension key in the fact table but does not have the corresponding dimension table.
Therefore, POS Transaction Number is a degenerated dimension.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is a Decision Tree Algorithm?
Explain difference between e-r modeling and dimentional modeling?
Explain how to export mappings to the production environment?
Suggest a good author for hyperion in data warehousing?
Explain conformed fact?
Explain the structure of cold fusion?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain what is partitioning? What are the types of partitioning?
What is is a star schema?
Explain what is data validation strategies for data mart validation after loading process?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain what are the modules in power mart?
What are data validation strategies for data mart validation after loading process?
Which component has onread method and what it is used for?
What is the difference between olap and oltp?
