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;

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

0 Answers  

---

For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,

---

What is called Cognos powerplay?

0 Answers  

---

What is the difference between a cascading report and drill through report?

0 Answers  

---

please tell me architecture of the cognos8?

4 Answers   IBM, TCS,

---

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  

---

Define the cognos reporting tool?

0 Answers  

---

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---

what are the types of facts ? explain them?

2 Answers   Business Objects, Informatica, Syntel, Teradata,

---

Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

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,

---

What is Metrics designer?

0 Answers  

---