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 |
is cognos 7 is better than cognos 8
..Architectural difference between cognos reportnet and cognos8?
What is the difference between a data mart and a data warehouse?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
what is mean by cognos powerhouse?
how to perform back drill through in cognos 8 what is the use of it
What do you mean by query studio?
------------------- What is Busschema?
what is filter?give me one example that you created a report in your project?
What is a query set?
diff b/w grouping and aggregation
what is mean of Meta data definistions?