in which scenario we go for views in cognos or oracle?



in which scenario we go for views in cognos or oracle?..

Answer / vanthian

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 ?    6 Yes 0 No

Post New Answer

More Cognos Interview Questions

how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,


------------- How to identify the Revenue Column in Report?

0 Answers  


in u r data u having duplicates how to fetch the latest data in our report?

2 Answers  


how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  


What is difference between page break and section report?

0 Answers  






what r the filters in fwm and report studio

6 Answers   TCS,


------------------What is Inline Query?

0 Answers   Cap Gemini,


Hi all, i have a requirement in Conditional drill through. I have a list report with Cities India, UK, USA, China, japan, Canada.... In the above cities i want to give Hyperlinks(Drill) for Only India & UK. Could you please send me the steps????

1 Answers  


Where do you edit cognos sql in report studio?

3 Answers   HCL,


How you will do the estimation for a task?

1 Answers   iGate,


pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com

1 Answers  


What are links & Segments in Cognos Framework Manager?

1 Answers   Systime,


Categories