wht is degenerated dimension ?it's uses?
- 10 Answers
- 48786 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
Answer Posted / nethaji
When a Fact table has dimension value stored it is called
degenerated dimension.Since a fact table doesn't store
textual items ,it should be stored in varchar datatype.
Why we are going?
Instead of maintaining a separate dimension table with
single values ,for eg.customer_policy_details='paid' ,we
can store it in fact table ,for performance.
| Is This Answer Correct ? | 12 Yes | 15 No |
Post New Answer View All Answers
What are the different problems that ?Data mining? can solve?
What is metadata in context of a datawarehouse?
Explain what is the difference between olap and datawarehosue?
How to import vsam files from source to target. Do we need a special plugin?
Which columns go to the fact table and which columns go the dimension table?
What are non-additive facts in detail?
What is a core dimension?
What is Active Datawarehousing?
What is cfapplication tag?
What is the difference between metadata and data dictionary?
How can we run the graph? How can we schedule the graph in unix?
What are the various tools? Explain name a few?
How to design file watch jobs?
What is cost benefit analysis (cba)?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
