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


Please Help Members By Posting Answers For Below Questions

What is meant by Reportstudio shortcut?

1712


Can you explain dynamic query mode?

573


What is cognos connection?

577


What are the advantages of using cognos sql?

645


What is meant by alternate drill down with ex?

608






--------------Diff b/w ODS and OLAP?

2741


What is the information present in the cognos configuration file?

526


Which studio is used to create reports?

591


What is difference between informatica power mart and power center?

554


How can I schedule reports in cognos?

585


What is the difference between set functions and filter function in dimensional data?

2499


how to explain health care project and which reports we can create in health care doain?

6341


What are the components of the report studio?

626


Can you define fan trap?

736


What are the other methods working as deployment functionality?

511