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 Here ive question on Reportnet when we save a report in reportstudio with what ext it save

6 Answers   iGate,

---

what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

0 Answers   Cognos, IBM,

---

how to improve performance in report studio level

1 Answers   Wipro,

---

we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

4 Answers   IBM,

---

diff b/w dimension and regular dimension

1 Answers  

---

in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day

2 Answers   IBM, iFlex, iGate,

---

. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.

3 Answers  

---

---------------How to identify First Record and Last Record?

2 Answers  

---

Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,

---

What do you mean by Drill down and Drill Up?

0 Answers  

---

What is a Cube?

0 Answers  

---

What do you mean by drill through report?

0 Answers  

---