Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52094 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 is the difference between dependent data warehouse and independent data warehouse?
How can you set the session management?
what are relationships?
Do you view contain data?
What is the purpose of Dataware Control?
List down some of the real time data-warehousing tools?
What are situations where snowflake schema is better than star schema when the opposite is true?
What are the advantages of cold fusion?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain about core dimension, balanced dimension, and dirty dimension?
What are the difference between snow flake and star schema?
What are diagrams?
What is the difference between a primary and secondary actor in use case modeling?
What is a real-time data warehouse?
What is data analysis? Where it will be used?
