Question { Wipro, 13337 }

2. What is With Clause In Cognos?

Answer

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;

Question { TCS, 18130 }

what is reprompt?

Answer

Reprompt returns prompt values.

when we using cascading prompt, there will be two value prompt, we can assign property for first value prompt auto submit=yes,when we assign like this, when we select value from first value prompt, the equivalent value will display in second value prompt,

without assign properties like this instead we can use reprompt.

Question { 7953 }

how to create calculate column in report studio

Answer

Using query calculation we can create a new calculated
column.

Question { Mphasis, 4782 }

if u having 2 pakages i want a report with report items in 2
pakages how to use the 2 pakages in single report please ans
me............

Answer

Hi,

We can't use 2 packages in a single report instead we
can add query subject from another package to the current
package. we can do this in framework manager.

Go framework manager then right click the namespace
then select new query subject then meta data wizard will
display in that u select data source name and then select
database object in that select query subject releated to
the another package. then finish the metadata wizard.
finally again publish the package.

Question { L&T, 5803 }

What is the basic difference between a sql and stored
procedure ?

Answer

SQL is a Language. Stored procedure is transact SQL statement.

Question { HSBC, 6759 }

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

Answer

You Can use Bitmap Index. Because while no.of unique record is small than no.of total record, we can use bitmap index. i.e we can use bitmap index in low cardinality column.

For example a table contain name,address,sex column. in sex column may be two values. i.e male and female. so this distinct values small but no.of total records is high.

So in this situation we can use bitmap index.