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 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|
which type of project we r going to snowflake schema
what is a join? what are the types of joins?
Difference between Express authoring mode and Professional authoring mode?
What is a Folder?
What is slicer & dicer ? what is sub session parameter ?
write the sql query to display 5th and 10th row in a table?
Define datastores in cognos?
what is a Galaxy Schema?
What is the difference between cognos 8.2 and cognos 8.3?
please please give me some banking calculations in framework manager.
What is Star schema group?
what does my folder and public folder contains? difference between the my folder and public folder?