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;

architecture of cognos8

1 Answers   IBM, Sonata,

---

What is Dynamic Grouping? what is diff between grouping n levelspan?

2 Answers   CybAge,

---

What is the difference between macro & Parameter

1 Answers   IBM,

---

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  

---

what is a query subjects item?

1 Answers   HCL,

---

---

Explain the workflow of your current project from end to end?what is the steps?

2 Answers   Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,

---

what is filter?give me one example that you created a report in your project?

3 Answers   IBM,

---

-----------------What is Singleton?

1 Answers   BoA, Cap Gemini, TCS,

---

How to crate cubes in transformer ?

3 Answers  

---

what is reprompt?

3 Answers   TCS,

---

What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?

4 Answers   Wipro,

---

what is the difference between java script and html in cognos?

1 Answers   IBM,

---