Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52132 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 the difference between filter and lookup transformation?
Explain the different types of data warehousing?
What is the difference between snowflake and star schema?
What is the difference between agglomerative and divisive hierarchical clustering?
Explain conformed fact?
What are non-additive facts in detail?
What a static and local variable?
Explain swot analysis?
What is the purpose of cluster analysis in data warehousing?
What are partition points?
Explain a linked cube?
What is crass reference table?
Explain dimension table ?
Explain what are the different types of data warehousing?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
