what are typees of dimensions
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 is mean of Meta data definistions?
i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..
what are burst options you have?
Explain about Parametermap?
can you apply grouping on crosstab?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
2. What is With Clause In Cognos?
what is differences between the group span and levelspan
What are the differences between Cognos 8 and Cognos 7.x version?
Are you aware of any limitations in Cognos?
Explain the workflow of your current project from end to end?what is the steps?
2 Answers Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,