wht is degenerated dimension ?it's uses?
- 10 Answers
- 48855 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 advantages of cold fusion?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Why is chameleon method used in data warehouse?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What are algorithms provided by Microsoft in SQL Server?
Explain what is the advantages data mining over traditional approaches?
What are the key columns in Fact and dimension tables?
What are the different models used in cluster analysis?
What is drill-through?
if you use oracle sql*loader , how do you transform data with it during loading?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain difference between snow flake and star schema.
Code the tables statement to produce a multi-level frequency?
How to calculate fact table granularity?
What are the types of partitioning?
