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
---------------Tell me about DWH Concepts?
what are the dimensions that you have in your current project?list them?
Can you define materialized view?
What are query items?
How create measures and dimensions?
Write various indexes used in cognos?
How do you call a store procedure within a transformation?
Can you define cognos impromptu?
How security is concerned with Reportnet? Explain its implementing steps.
What are the different types of reports present in cognos?
How can I test reports in cagonos?
What is a Query Subject?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What are slice and dice?
Explain difference between powerplay transformer and power play reports?