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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   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 
How can you improve performance in report studio level?
What is the difference between Cognos sql and Native sql?
How can you create cubes in framework manager?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
Answer
# 1		 
report studio performance depends on net work spead,
complex calculations,using not in operator,outterjoin.
Cognos SQL and Native SQL are two different types of SQL 
generated by cognos tool. Native SQL is sub set or same as 
Cognos SQL.
Native SQL contains only the functionality that got 
executed at database end, apart from this Cognos SQL will 
have the Locally processed logic as well.
we can create package using cube.Cube is a data source here.
 
Is This Answer Correct ?    1 Yes 0 No
Ushasree
[Patel]
 
  Re: How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
Answer
# 2		 
u can create cube in FM using externalise property.
 
Is This Answer Correct ?    0 Yes 0 No
Abc
 
 
 
  Re: How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
Answer
# 3		 
by using simple case statements and minimising the complex 
calculations and applying the frequently used filter 
conditions at the framework level instead of applying them 
in the report level we can improve the performance.By 
implementing distributed configuration we can improve the 
performance. 

we can create IQD's in the framework level and use these 
IQD's to create cubes in powerplay.
 
Is This Answer Correct ?    3 Yes 0 No
Neelima
 
  Re: How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
Answer
# 4		 
By using less number of filters, avoiding complex
calculations , and distributing configuration we can improve
performance in report studio ..........

cognos sql  statement is created irrespective to database
but native sql statement is created respective to database
which is using .......

we can't create cubes in frame work manager ......there is
no other scope to create cube other than Power play
transformer....

If i am wrong ,point out me please...

It's madhoo
 
Is This Answer Correct ?    0 Yes 0 No
Madhoo
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?  2
How to crate cubes in transformer ?  2
what is textsource variable HCL1
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...  1
wt is tupple , Embed function ? wt is regular dimension ?  1
How to configure the Cognos configurations to work in the Windows 2000 Server machine? Infosys1
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package? TCS3
how many types of formats you can run a report using cognos? HCL1
How we check the errors before running the report,plz let me know the answer TCS2
Explain the different stages in creating a report in cognos report net?  1
whis meant by Thumbnails on cagnos?  2
Whrer u can save the Report net documentation in our local system?  1
what is mean of Meta data definistions? IBM2
Is cognos models are version compatible?  2
what is cardinality that you can give to employee and department query subjects in framework manager? HCL1
in which scenario we go for views in cognos or oracle?  1
What are the different ways of adding data in Transformer?  1
how many facts&dimensions tables in project? it's very urgent.........  2
What is the use of Excel files in Cognos8?  1
what is the difference between count and running-count functions?  1
 
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