Interested to Buy Any Domain ? << Click Here >> for more details...
in which scenario we go for views in cognos or oracle?
- 1 Answers
- 6695 Views
- I also Faced
- E-Mail Answers
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 are all the types of report?
how to create measures and dimensions?
what is the difference between list report and crosstab report?
What is difference between page break and section report?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is called materialized view?
What are query items?
What are the other methods working as deployment functionality?
what are the errors faced while bursting the reports and how to solve those errors?
What is the difference between a cascading report and drill through the report?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
How can create users and permissions in cognos?
What is the use of powerhouse?
what is the difference between querystudio in reportnet and cognos8
i have one file i saved in csv how can i take these file into framework manager
