Interested to Buy Any Domain ? << Click Here >> for more details...
what is view? types of views?
- 3 Answers
- 8067 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
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;
| Is This Answer Correct ? | 0 Yes | 0 No |
i was asked what are the caluclations done by you in your report? plz give reply
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
what is drill down and slicing and dicing what are the difference between them?
How can we do the unit testing?
What is RenderVariable?
wt is tupple , Embed function ? wt is regular dimension ?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
Can we install cognos on windows 7?
-------------What is Coditional Prompting?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
Teradata 
