wht is degenerated dimension ?it's uses?
- 10 Answers
- 49547 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 main difference between inmon and kimball philosophies of data warehousing?
Explain meta data?
What are aggregate tables and aggregate fact tables?
What is the definition of cube in datawarehousing?
What is Sequence clustering algorithm?
What is data stream and data adaopter. Is it same are different? Explain?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Explain the difference between data ware house & data mart?
Explain a mapping, session, worklet, workflow, mapplet?
explain about balanced dimension,
Explain what is fact less fact table? Where you have used it in your project?
What are the various file formats involved in reportnet?
Which component has onread method and what it is used for?
Explain the versions of reportnet?
what is an use case?
