what are typees of dimensions
- 5 Answers
- 8414 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 |
Interval Prompt's Usage? Example for usage in Project
-----------------What is Determination Model?
I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh
can you apply grouping on crosstab?
How can we create regular dimensions & measure dimensions?
what is power prompt in cognos ep7series?what is the use of this?
--------------Explain Table of contents?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What are the types of catalogs in cognos?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What do you mean by drill across?
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
Teradata 
