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

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

531


Explain a mapping, session, worklet, workflow, mapplet?

611


what are relationships?

609


I know of using applysimple, but there are other ways too?

569


Define Data Warehousing?

750






Tell me what is degree of a relation?

532


What is the very basic difference between data warehouse and operational databases?

471


Explain what are the basic needs to join two sources in a source qualifier?

528


Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

594


Explain what is the advantages data mining over traditional approaches?

594


What is freehand sql?

617


Why should you put your data warehouse on a different system than your oltp system?

508


Compare and contrast aggregates & indexes

3353


Explain difference between e-r modeling and dimentional modeling?

580


Explain piconet?

555