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
how can you get the errors in job? when loops are araised we get error?
Define olap designer?
What is difference between primary key and unique key constraints?
Why are meta service important then other services?
How do you call a store procedure within a transformation?
What is called cognos reporting tool?
What is called a slice?
what are the dimensions that you have in your current project?list them?
-----------With out using DrillThrough how to do Reports?
What are all the components of Report Studio?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you define query studio?
What is the difference between Standard and Metrics folder?
What is meant by alternate drill down with ex?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.