Interested to Buy Any Domain ? << Click Here >> for more details...
what are typees of dimensions
- 5 Answers
- 9549 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 limitations of cognos reportnet? What are the enhancements in reportnet ?
difference between join and union in reportstudio?
What is the basic relationship between measures and dimensions in transformer modelling
What do you understand by user class in cognos?
WHAT ARE THE TYPES OF LIST REPORTS?
What is Outerjoin?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What is Online View?
how u provide security in power play transformer???
3 Answers iFlex, ITC Infotech, TCS,
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview
Teradata 
