Interested to Buy Any Domain ? << Click Here >> for more details...
2. What is With Clause In Cognos?
- 2 Answers
- 14278 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 |
What is Star schema group?
-------------What is a Conformed Dimension?
What is Merging, Segments and porting in Framwork Manager?
What is called Cognos powerplay?
Wt is the Diff between Business Key & member caption?
What is catalog and types of catalogs in cagonos and which is better?
Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.
Explain the Difference Between Bursting and Scheduling?
How create measures and dimensions?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
Can you define metrics designer?
What is the difference between the standard and metrics folder?
Teradata 
