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   interview questions urls   External Links  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 
in which scenario we go for views in cognos or oracle?
 Question Submitted By :: Meena
I also faced this Question!!     Rank Answer Posted By  
 
  Re: in which scenario we go for views in cognos or oracle?
Answer
# 1		 
As far as I Know

Oracle views are nothing but the virtual copy of the table.

the only differnce is we can't alter the table structure 
(i.e) we cant perform the insert,edit delete operations for 
the table..once we are using the oracle views in cognos

whenever a new dataitem is added to the existing table  
then the view will be updated using the Create or Replace  
option and the view will be deployed once again so that the 
new dataitem will be added to the view

Consider a scenario,in which the Datamodelling team will 
design or create the tables and they deploy the views for 
the tables

The Cognos team will then use the views as the Source for 
their tables and they create Packages using the views
 
Is This Answer Correct ?    3 Yes 0 No
Vanthian
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
How many number of cubes can we create on a single model? How can we navigate between those cubes?  1
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...  1
What is Report item TCS1
Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...  1
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz? Polaris1
what are the joins present in reportnet?which is most widely used? Covansys3
How to hide/unhide the prompts which are not used by unauthorized users?  2
how many facts&dimensions tables in project? it's very urgent.........  2
explain project, package ,model , modelers.........and differences b/w them? HCL3
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?  1
How can we improve performance in report studio level?  1
Can we create reports using OLTP database?How?  3
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
Can anyone tell me the step by step process how to connect cognos to oracle?  2
What are the steps involved in migrating CRN enviroment to Cognos 8? BMW2
How to Create users in cognos Access Manager from 1) front end 2) back end TCS1
What is meant by Tabular SQL in Cognos Report net Infosys2
where do we see the run time of the report ?  1
can reportnet supports cubes??? Wipro2
what is cognos architechure Cap-Gemini2
 
For more Cognos Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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