Interested to Buy Any Domain ? << Click Here >> for more details...
what are typees of dimensions
- 5 Answers
- 9321 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh
Conformed Dimension,Degenarated Dim,Junk dim those all are
concepts in DWH. But in Cognos we have some more dim like
Regular dims,Measure dim
Regular Dim Mainly it is used for drill up and drill down
purpose. It contains Hierarchial structure. It have three
propertise having Business key,member Caption,member
description.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / gowtham
there are 3 types
1. junk dimension:: junk dimension is nothing but unwanted data
ex: spam
2. conformed dimension:: a dimension which can reuse access the multiple facts table
3. degenerated dimension:: at the time of any
transaction it will give temporarily id
ex: self desk, invoice number,
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
4 types
Conform Dimension
Junk Dimension
degenerated Dimension
Role play Dimension Ex-Date
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
Conform Dimension
Junk dimension
degenerated Dimension
Slowly Changing Dimension
Role play Dimension.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.
How can create users and permissions in cognos?
pls any body give the cognos 8 versions release year.
How can we improve performance in framework manager level?
How to create Events?
How to schedule the report twice in a day?
what is the difference between java script and html in cognos?
How to do deployment?
how to perform single sign in cognos by using url?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Teradata 
