wht is degenerated dimension ?it's uses?
- 10 Answers
- 48859 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 are data validation strategies for data mart validation after loading process?
what is difference between drill & scope of analysis?
What is data warehouse architecture?
Explain reference cursor?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is the function of surrogate key in data warehousing?
Can we take backup when the database is opened?
What is the difference between ods and oltp?
what are the different views that are considered when building an object-oriented software system?
Explain why fact table is in normal form?
What is Discrete and Continuous data in Data mining world?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
How to pivot data using informatica when you have variable amount of pivot rows?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is a real-time data warehouse?
