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.

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.

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,

Answer / gopal

4 types

Conform Dimension
Junk Dimension
degenerated Dimension
Role play Dimension Ex-Date

Answer / gopal

Conform Dimension
Junk dimension
degenerated Dimension
Slowly Changing Dimension
Role play Dimension.

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers   HCL,

What is Fullouterjoin?

0 Answers  

1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

1 Answers   CTS,

how u migrate reports to cognos 8 from previous versions

3 Answers   TCS,

Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

1 Answers   IBM,

Give the advantages of cognos?

0 Answers  

what is catalog and types of catalogs in cagnos and which is better?

0 Answers   IBM,

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  

tell me the creation of Snapshots?

2 Answers  

How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?

1 Answers   Mind Tree,

what is the difference between native sql and cognos sql?

0 Answers  

what is session parameters? what is use?

1 Answers   HCL, Satyam,