Interview Questions Answers in Business Objects, SQL PLSQL

vinodkumar

{ City } bangalore
< Country > india
* Profession *
User No # 52773

Total Questions Posted # 9
Total Answers Posted # 2

Total Answers Posted for My Questions # 19
Total Views for My Questions # 74679

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { vinodkumar }

Questions Answers Category Views Company eMail

When we go for OLAP , and When we go for OLTP for generating the reports ?

Honeywell,

3 Business Objects 9361

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 Business Objects 4895

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

HCL,

2 Business Objects 5442

Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?

3 Business Objects 7136

What is the Difference b/w Server based Ranking and normal Ranking?

1 Business Objects 6816

Can anybody explain what mean by Database Delegated Measures?

TCS,

2 Business Objects 21303

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 Business Objects 3764

What is the difference b/w the simple Universe and Complex Universe?

2 Business Objects 7250

Aliases and Contexts Which once will give the better performence when resolve the loops?

HCL,

3 Business Objects 8712

Answers / { vinodkumar }

Question { Cognizant, 361236 }

how to find the second highest salary from emp table?

Answer

select *from(select *from emp orderby sal desc)where
ronum<=2 minus select *from (select *from emp order by sal
desc ) where rownum<=1;

Is This Answer Correct ?

0 Yes

0 No

Question { L&T, 8328 }

What is scope of analysis ?

Answer

Scope of analysis can be done based on the hierarchy defined at the universe level.

Exp store=>product=>order

http://fkrt.it/DeK1vuuuuN
Www.bohelper.com

Is This Answer Correct ?

0 Yes

0 No