sanket mishra


{ City } bhubaneswar
< Country > india
* Profession * senior systems engineer
User No # 52272
Total Questions Posted # 0
Total Answers Posted # 7

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 15
Users Marked my Answers as Wrong # 36
Questions / { sanket mishra }
Questions Answers Category Views Company eMail




Answers / { sanket mishra }

Question { IBM, 6001 }

what are summary filters? grouped filters?


Answer

There is no difference between summary filters and grouped
filters:
For version 8.3 and above ... we use the term summary
filter and for lower versions we say grouped filters.

Is This Answer Correct ?    0 Yes 2 No

Question { HCL, 5420 }

Which service handles requests for cognos connection,query
studio and event studio.


Answer

It is the apache Tomact server which handles all web based
applications.
IIS can handle only dotnet based applications, hence not
true.

Is This Answer Correct ?    0 Yes 2 No


Question { Wipro, 8964 }

Why we should go for cognos? when there are so many other
BI(Reporting) tolls in front of us?


Answer

It is a fully web based application: which means that
reports can be created from any client system, saved in the
server and can be accessed by anyone.

Unlike BO, cognos can be opened from anywhere without any
desktop installation.

Hope that suffices....

Is This Answer Correct ?    6 Yes 1 No

Question { HCL, 8666 }

Where do you set security levels for users in reports?


Answer

We can set the security level for users using Cognos macros.
For more details refer ... Cognos 8 by Dan Volitich

Is This Answer Correct ?    1 Yes 0 No

Question { 14544 }

how to find 5th row ?


Answer

select * from table t1 where rownum = 5 ;

Is This Answer Correct ?    1 Yes 31 No

Question { Cap Gemini, 8182 }

in a table it has 200 rows the query is select 150 from
tablename.whats the output


Answer

select 150 from tab
Ans:150
150
150
--
--
150(200 times)

Is This Answer Correct ?    7 Yes 0 No

Question { 6284 }

write sql query following table
amount year quarter
1000 2003 first
2000 2003 second
3000 2003 third
4000 2003 fourth
5000 2004 first
6000 2004 second
7000 2004 third
8000 2004 fourth

i want the output
year q1_amount q2_amount q3_amount q4_amount
2003 1000 2000 3000 4000
2004 5000 6000 7000 8000

can anybady help me to achieve the aboue result by using informatica.

thanks in advance.


Answer

Select year,
sum(case when quarter = 'first' then amount end) AS q1_amount,
sum(case when quarter = 'second' then amount end) AS q2_amount,
sum(case when quarter = 'third' then amount end) AS q3_amount,
sum(case when quarter = 'fourth' then amount end) AS q4_amount

from table
group by year order by year

Is This Answer Correct ?    0 Yes 0 No