wht is degenerated dimension ?it's uses?

Answer Posted / krishna murari

These are some date elements in the operational system
which are neither fact nor strictly dimension attributes.
These are useful for some kind of analysis.
These are kepts as attributes in fact table called
degenerated dimension

Is This Answer Correct ?    21 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you define data block size?

583


Explain the data type of the surrogate key?

556


Explain what is the difference between power center & power mart?

511


What is the difference between power center & power mart?

496


Explain can report net connect multiple datasource at a time in report creation time?

481






In a star schema, are foreign key constraints between facts and dimensions neccessary?

531


Explain what are the advantages of query studio compared to report studio?

538


What is Discrete and Continuous data in Data mining world?

2106


Can any one explain about core dimension, balanced dimension, and dirty dimension?

625


How to performance tune reports?

567


What is the difference between olap and datawarehosue?

496


What is the difference between drill through and masterdetail reports?

527


What is Sequence clustering algorithm?

1524


What are various warehousing tools?

570


What is a real-time data warehouse?

578