Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

which type of project we r going to snowflake schema

0 Answers   IBM,

what is a join? what are the types of joins?

5 Answers   HCL, Satyam,

Difference between Express authoring mode and Professional authoring mode?

2 Answers   Wipro,

What is a Folder?

0 Answers  

What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,

write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,

Define datastores in cognos?

0 Answers  

what is a Galaxy Schema?

2 Answers   IBM,

What is the difference between cognos 8.2 and cognos 8.3?

5 Answers  

please please give me some banking calculations in framework manager.

0 Answers  

What is Star schema group?

1 Answers   IBM,

what does my folder and public folder contains? difference between the my folder and public folder?

3 Answers   HCL,