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 |
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
How will you migrate your reports to QA environment?
which difficult you faced in your project?
what is cardinality that you can give to employee and department query subjects in framework manager?
how u provide security to reports??how u provide security to packages ?
What is defined as Query studio?
what is catalog and types of catalogs in cagnos and which is better?
What is the difference between cognos 8.2 and cognos 8.3?
There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)
New coloums are added in database, then how you know in report level
Can you define dimension?
Define cognos report net?