Interested to Buy Any Domain ? << Click Here >> for more details...
in which scenario we go for views in cognos or oracle?
- 1 Answers
- 6779 Views
- I also Faced
- E-Mail Answers
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 |
Diff b/w Crossproduct and Outerjoin?
difference between boxtype and visiable
what is loop in frameworkmanager ?
What are all types of prompt?
2. What is With Clause In Cognos?
What is meant by junk dimension?
How you will do the estimation for a task?
What are the Ways to Import Data into Catalong?
Write types of folders present in cognos?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What is the difference between filter & Condition?
What is meant by Tabular SQL in Cognos Report net
Teradata 
