nethaji


{ City } chennai
< Country > india
* Profession *
User No # 11350
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 12
Users Marked my Answers as Wrong # 15
Questions / { nethaji }
Questions Answers Category Views Company eMail




Answers / { nethaji }

Question { Infosys, 48696 }

wht is degenerated dimension ?it's uses?


Answer

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