1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

you have two tables table 1 contains emp id,name and deptno
and tble 2 contains only depatment number some of the
depatment no of 1st table are not present in table 2 how
will you create a report only to get the departments of
which excess in table 1

Question Posted / soni

Answers were Sorted based on User's Feedback



you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / taruna

The question is 'how to create a report' and not database query!!! We may apply MINUS operator between the two queries in query panel. This will give the difference.

Is This Answer Correct ?    6 Yes 0 No

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / vishal

select a.empid, a.name, a.deptno from table1 a, table2 b where a.deptno != b.deptno

Is This Answer Correct ?    8 Yes 6 No

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / rajesh kumar

select empid,name,depno from table1,table2 where
table1.deptno not in table2.deptno

Is This Answer Correct ?    5 Yes 3 No

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / amutha

select empid,name,depno from table1,table2 where table1.deptno=table2.deptno(+)

Is This Answer Correct ?    3 Yes 10 No

Post New Answer

More Business Objects Interview Questions

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,

Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?

2 Answers  

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers  

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers  




can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  

What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  

What is meant by data federator and what is the use of it?

2 Answers   TCS,

Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important

7 Answers   Zylog,

in sap bi we have wad, then why we go for sap bo

0 Answers  

What is mean by tuning the report?

1 Answers  

What is the size of data base?

2 Answers  

For more Business Objects Interview Questions Click Here
Categories