what is view? types of views?

Answer Posted / 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.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Additive function?

1558


Can we test the report other than manual testing?

1662


What is a Query Subject?

661


4. How many dimensions did you use in your reports?

1494


I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

1624






What are initial page components of Cognos connection?

610


What are the different uses of a repository manager?

603


Explain the difference between powerplay transformer and power play reports?

602


What are all the types of hierarchies?

674


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1600


Explain the characteristics of cognos?

611


What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

1670


how to create measures and dimensions?

612


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

618


what do u mean by bridge group? where we r using this one?

1545