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

New coloums are added in database, then how you know in report level

1253


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1786


how can you get the errors in job? when loops are araised we get error?

1759


Explain is there any comparison available for cognos reportnet vs crystal reports?

638


what are the dimensions that you have in your current project?list them?

1687






What is the use of cognos decision stream?

742


What is model?

643


Can you define snapshot?

623


What are all the types of report?

651


How to generate cubes in cognos?

648


What is called materialized view?

685


can you tell me what are the dimension tables are used in project

1971


What are initial page components of Cognos connection?

692


What is the advantage of using shortcuts?

722


tell me two or three issues from client side and how to solve those issues?

1795