Question { Genpact, 33438 }

How can you improve performance in report studio level?
What is the difference between Cognos sql and Native sql?
How can you create cubes in framework manager?

Answer

By using less number of filters, avoiding complex
calculations , and distributing configuration we can improve
performance in report studio ..........

cognos sql statement is created irrespective to database
but native sql statement is created respective to database
which is using .......

we can't create cubes in frame work manager ......there is
no other scope to create cube other than Power play
transformer....

If i am wrong ,point out me please...

It's madhoo

Question { HCL, 10626 }

write a query to display to 10 max record from the employee
table?

Answer

select * from emp a
where (select count(distinct sal) from emp b where
a.sal /


this is the exact query........when there are duplicate
salaries are there also........

Is This Answer Correct ?

0 Yes

5 No

Question { HCL, 12011 }

write a query to display to 10 max record from the employee
table?

Answer

You are question is not clear.....you need decide based on
which column you want first 10 records.....

if you work on Salary column this is the query .......

select distinct sal from emp a
where (select count(*) from emp b where a.sal order by sal desc
/

Any queries on Sql please feel free to ask me i am very
interest in it......

Is This Answer Correct ?

7 Yes

0 No