Interested to Buy Any Domain ? << Click Here >> for more details...
2. What is With Clause In Cognos?
- 2 Answers
- 14371 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thanjairajan@gmail.com
The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated references to the subquery may be more efficient as the data is easily retrieved from the temporary table, rather than being requeried by each reference.
For example:
WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / krishna
Specifies whether to send a request to the database using
an SQL WITH clause. When set to Yes, and if the database
supports WITH clauses, a WITH clause request is generated.
When set to No, or if the database does not support WITH
clauses, a request using derived tables is generated
| Is This Answer Correct ? | 1 Yes | 2 No |
5. Which type of report you build more, list, crosstab or chart and why?
Explain about embedded & standalone filters?difference between them
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 is an sid (surrogate key)?
Define the slice and dice?
how u provide security to reports??how u provide security to packages ?
What junk dimension contains?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
what is the generated prompt,how can i use?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
How to schedule the report twice in a day?
What is looping and how to avoid it in framework manager?
Teradata 
