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 the difference between list report and crosstab report?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the size of database for you project?
Give the advantages of cognos?
How is cognos model organization works?
What are all the types of hierarchies?
What is a Pivot?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
Diff b/w Crossproduct and Outerjoin?
how u will design the report if the objects are available
What are the advantages of shortcuts?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How to deploy from one server to another server?
Explain what is the difference between native sql and cognos sql?
Why are meta service important then other services?