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

What are the differences between datamart vs. Reporting cube?

491


what is user variable in affinium campaign? and some real time examples.

3693


What is many-to-many dimensional model in datawarehousing ?

514


Explain why are oltp database designs not generally a good idea for a data warehouse?

628


Explain dimension table ?

562






Suggest a good author for hyperion in data warehousing?

562


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

506


How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

497


Which columns go to the fact table and which columns go the dimension table?

576


Why is chameleon method used in data warehouse?

697


Explain what is the limit to the number of sources and targets you can have in a mapping?

547


List down some of the real time data-warehousing tools?

561


What is informatica architecture?

611


Explain what is the advantages data mining over traditional approaches?

586


Explain the difference between keylokup and joiner?

507