Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52402 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
Compare aggregates and data marts
What is VLDB?
Explain difference between data ware house & data mart?
Explain what does level of granularity of a fact table signify?
Define Data Warehousing?
What is data analysis? Where it will be used?
Why fact table is in a normal form?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are the possible data marts in retail sales?
In microstrategy, how can we direct the sql generated to use a specifc table?
How can you communicate with web server (apache or iis) from coldfusion?
What are the key features of chameleon that separates it from other algorithms?
What is the use of dimensional modeling in data warehousing?
What is dimensional modelling?
Explain what is ods (operation data source)?
