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 |
What are the steps to import the two data sources in framework manager?
How to test a cube?
What is set to be cardinality?
what is the diffence between render variable & style variable with egs? Plz reply ASAP
What is the difference between filter & Condition?
How to create model and how to test model?
---------------Describe OLAP Reporting and RDBMS Reporting?
------------What is Slicer memberset?
9. What was the most complex type of report you dealt with?
What is a dashboard in Cognos Report Studio and how do we creae it
---------- Purpose of Factless Facttable?
Can you define drill down and drill up?