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;

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

Can you define metrics designer?

0 Answers  

---

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

0 Answers  

---

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

0 Answers   IBM,

---

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

2 Answers   Satyam,

---

What are the steps involved in migrating CRN enviroment to Cognos 8?

3 Answers   BMW, Goyal Group, Mersan,

---

---

What is Tool Tip? and how to create in report studio?

1 Answers   Wipro,

---

What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

2 Answers   DELL,

---

---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers   Bank Of America,

---

tell me the creation of Snapshots?

2 Answers  

---

what use of surgate key in project

3 Answers   HCL, TCS,

---

How do you test the performance of a report?

3 Answers   TCS,

---

how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?

8 Answers   HSBC,

---