in which scenario we go for views in cognos or oracle?
Answer Posted / 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 View All Answers
What is meant by Reportstudio shortcut?
Can you explain dynamic query mode?
What is cognos connection?
What are the advantages of using cognos sql?
What is meant by alternate drill down with ex?
--------------Diff b/w ODS and OLAP?
What is the information present in the cognos configuration file?
Which studio is used to create reports?
What is difference between informatica power mart and power center?
How can I schedule reports in cognos?
What is the difference between set functions and filter function in dimensional data?
how to explain health care project and which reports we can create in health care doain?
What are the components of the report studio?
Can you define fan trap?
What are the other methods working as deployment functionality?