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

what is hints in cognos and where we use it.

0 Answers   Satyam,

What is meant by Tabular SQL in Cognos Report net

3 Answers   Infosys,

what is the difference b/w mdx and sql?

4 Answers   Cap Gemini, IBM,

diff b/w grouping and aggregation

1 Answers   HCL,

My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333

1 Answers  

I want to schedule the report as sysdate-1.....how to do

2 Answers   TCS,

we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

2 Answers   Accenture,

cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  

What is the use of Tree Prompt? Where it is used?Pls give me a real time example?

1 Answers  

i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

1 Answers  

Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...

1 Answers  

What is RenderVariable?

5 Answers  

For more Cognos Interview Questions Click Here
Categories