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   To Refer this Site to Your Friends   Click Here
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
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.
 Question Submitted By :: Balaji
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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.
Answer
# 1
yes we can create cube from multiple iqd's , we have to 
first import the primary datasource which contains most of 
the structural data item required for the cube creation, 
and then other sources,by inserting the data source 
separately.
Good practises:
1. we can incrementally update the cube.
2.check the cube status periodically
3.run the test cube with a small amount of data.eg., if you 
have 1000 records , we can assign 300 records from each 
data source and perform a sample test cube.
4.we can do partition, to improve the runtime performance.
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 
  Re: 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.
Answer
# 2
yes we can create a cube with multiple IDQ's as data 
sources,for this insert data source of tyye Impromptu Query 
Definition in Transformer model.
afer creating a cube u can---
1)Partition a cube 
2)Update a selected cube by batch file or by macro  
3)Apply security to a cube
4)Compress a cube.
5)Publish that cube on Upfront.
6)Use that cube as DataSource  in  FM in Cognos Series 8
 
Is This Answer Correct ?    0 Yes 0 No
Vijaya Yadav
 
 
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
What is an open session command in cognos connection?what is it meant for? Infosys1
what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.  1
How to hide/unhide the prompts which are not used by unauthorized users?  2
what is the security module used in cognos?  2
what is an associated query?  2
How to connect three fact tables? TCS6
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how? TCS2
what is prompt variable HCL1
How do you use SUM function in Reportnet? IBM2
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,  1
what is logs in cognos Target1
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.  1
What's the differance between each studio in cognos 8? TCS1
what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)? IBM1
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!  1
What are the different ways of adding data in Transformer?  1
write a query to display the third record from the employee table? HCL2
can reportnet supports cubes??? Wipro2
what is the automation tool used for data warehouse testing??? Covansys2
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
 
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