Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52133 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
Explain what are the vaious etl tools in the market?
What are necessary tasks to install reportnet software?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is Discrete and Continuous data in Data mining world?
How many types of facts and what are they?
Explain what are components of report studio?
How to performance tune reports?
Explain the importance of data warehouse?
What is factless fact tables?
Explain Association algorithm in Data mining?
In microstrategy, how can we direct the sql generated to use a specifc table?
What is cost benefit analysis (cba)?
Where the cache files stored?
Explain what are the mapping paramaters and maping variables?
What are the other names given to data warehousing?
