Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

in which scenario we go for views in cognos or oracle?

Question Posted / meena


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

Post New Answer

More Cognos Interview Questions

Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

2 Answers   Mphasis,

Can you define dimension?

0 Answers  

How to hide/unhide the prompts which are not used by unauthorized users?

3 Answers  

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

0 Answers  

what is the difference between Cognos EP7 series and Congos8?

2 Answers   Hexaware,

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

2. What is With Clause In Cognos?

2 Answers   Wipro,

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

0 Answers  

what is fact less fact give me proper example?

2 Answers  

wt is scope relationship?

2 Answers  

what is Cognos Visualizer and Cognos Scripting?

3 Answers  

What are the types of hierarchies?

0 Answers  

For more Cognos Interview Questions Click Here
Categories