Answer / k naveen kumar

View is mirror image to the base table(main table) i,e it is
a logical pointer to the base table.
for the view it does not occupy space for the data but it
occupy space for the structure
Two types of views
1) simple 2) complex view
simple view created on single table
complex view created on multiple tables.

Answer / arangaraj

A view is a tailored presentation of the data.contained in
one or more tables or other view.it takes the o/p of a
query and treat it as a table. it does n't require any
space in database.

ex.create view emp1 as select empno,empname from emp;

types of view:Materialised view.

Answer / arkchowdary

A view is, in essence, a virtual table. It does not
physically exist. Rather, it is created by a query joining
one or more tables.

Creating a VIEW
The syntax for creating a VIEW is:

CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

0 Answers  

---

There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

2 Answers   BitWise,

---

Is there any comparison available for Cognos Reportnet Vs Crystal reports?

0 Answers   IBM,

---

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

0 Answers   IBM,

---

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

0 Answers   Wipro,

---

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

0 Answers   HCL,

---

what is the main advantage of impromptu over cognos reportnet?

0 Answers  

---

where do we see the run time of the report ?

2 Answers  

---

my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?

1 Answers   IBM,

---

How to create multilingual reorts?

4 Answers  

---

How to give a securites in object level&datalevel&pakege lavel in frame work manager?

1 Answers  

---

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

2 Answers   TCS,

---