Interested to Buy Any Domain ? << Click Here >> for more details...
what is view? types of views?
- 3 Answers
- 7888 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 am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....
What do you mean by drill through report?
I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name
How to pass multiple values from picklist prompt to sub report filter?
Is cognos models are version compatible?
------------------What is Focalpoint?
What are the methods by which it non-durable model could be changed into the durable model?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
how can you set the image in the report
how to hide a particular pages at time if you get blank pages
what are the enhancements in cognos reportnet ?
Teradata 
