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 is the use of AFD? Where it can be stored?

1 Answers  

How do u Receive requiremnts from the client?

3 Answers  

can u create report to connect oracle and sqlserver at a time?

2 Answers   Zensar,

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers   TCS,

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 Answers  

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

3 Answers   iFlex,

I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

39 Answers   TCS,

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1 Answers  

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1 Answers  

When we are going for Shortcut join and why.

1 Answers   Cap Gemini,

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,

For more Business Objects Interview Questions Click Here
Categories