what are typees of dimensions

Answer Posted / m m naidu

Types of dimensions:

1.Conformed dimension:A dimension which can be shared by
multiple fact table is known as conformed dimension

2.Junk dimension:A junk dimension is a collection of random
transactional codes, flags and/or text attributes that are
unrelated to any particular dimension.
simply to say a randomly used dimension is junk dimension

3.Degenerated dimension: It is a dimension which has only a
single attribute. This dimension is typically represented as
a single field in fact table. These dimensions are used when
fact tables represent transactional data.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is set to be cardinality?

630


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10731


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1547


Can you define metrics designer?

596


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

1867






What is the function of cognos dispatcher?

585


How do we convert from Numeric to be Words?

2500


Why cognos scenario is used?

577


What is the difference between set functions and filter function in dimensional data?

2508


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1620


Define query items?

592


What is cognos reporting tool?

603


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1506


How Metrics Studio is better than Report Studio?

2028


faq's on cognos

3623