ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Cognos
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what are typees of dimensions
 Question Submitted By :: Sekhar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what are typees of dimensions
Answer
# 1
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 ?    1 Yes 0 No
M M Naidu
 
  Re: what are typees of dimensions
Answer
# 2
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 ?    0 Yes 0 No
Ramesh
 
 
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
what is the difference between cascading prompt and drill-thru  3
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?  3
Wt is the Diff between Business Key & member caption?  1
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer. Satyam2
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer. TCS3
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com IBM1
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...  1
what are the applications of the tabular model ???? iGate4
How you create IQD In ReportNet FrameWork?  3
Whrer u can save the Report net documentation in our local system?  1
How to configure the Cognos configurations to work in the Windows 2000 Server machine? Infosys1
How to hide the prompts  1
What is the difference between cognos 8.2 and cognos 8.3?  4
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance.... IBM1
what is render variable Cap-Gemini3
Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.  1
16. How can we create top 10 and bottom 10 records in the same list? TCS2
What are the steps involved in migrating CRN enviroment to Cognos 8? BMW2
Is it possible to apply access manager user rights in impromptu?  1
how u migrate reports to cognos 8 from previous versions TCS2
 
For more Cognos Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com