wht is degenerated dimension ?it's uses?
- 10 Answers
- 48848 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
Explain what is power center repository?
What is cfapplication tag?
Compare cold fusion with other programming languages?
What is many-to-many dimensional model in datawarehousing ?
What is Analysis Services?
Explain is fact table?
Give some difference between oltp and olap.
What are the different models used in cluster analysis?
Explain a mapping, session, worklet, workflow, mapplet?
What is the difference between static cache and dynamic cache?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain dimensional modelling?
Explain how to get the first 100 rows from the flat file into the target?
I have two universes created by two difference database can we join them in designer & report level? How
Explain the data type of the surrogate key?
