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
What are the methods by which it non-durable model could be changed into the durable model?
What do you understand by the cognos?
How do we drill through from a powerplay cube to reportnet?\
----------------Describe DWH Architecture?
Why is auto-regression used in forecasting used on cognos platform?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What is Metrics designer?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
------------ Diff b/w MemberCaption and MemberDescription?
What are all types of Batches?
What is the size of the cube?
-------------What is Coditional Prompting?
What are the types of security?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What is metric store database?