Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52438 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
Explain ddl (data definition language)?
Explain is fact table?
What is the difference between dependent data warehouse and independent data warehouse?
Explain normalization?
What is data stream and data adaopter. Is it same are different? Explain?
What is surrogate key? Where we use it explain with example?
How to improve session performance in aggregator transformation?
What are non-additive facts in detail?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What are Non-additive facts?
Suggest a good author for hyperion in data warehousing?
Explain what are the various reporting tools in the market?
What is surrogate key? Where we use it?
Explain what is data validation strategies for data mart validation after loading process?
What are the stages of datawarehousing?
