Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 51704 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
How to create prompts in report net?
Explain what is analytical or analytic mean?
Explain what are data marts?
What are the main steps to build the data warehouse?
How can we schedule the graph in unix?
Explain the definition of normalized and denormalized view and what are the differences between them?
Start a batches with in a batch?
What is Discrete and Continuous data in Data mining world?
What is real-time datawarehousing?
After the complete generation of a report who will test the report and who will analyze it?
What is cubes?
How to stop a batch?
Explain which are the olap tools available that are supported by oracle?
What is the difference between junk dimension and degenerated dimension?
Could any one explain me how to create cascading prompts?
