I have 2 tables. Table 1 is employee table and Table2 is department table. In e

I have 2 tables. Table 1 is employee table and Table2 is
department table. In employee table i have 1,2,3,4,5 emp
id's,in Dept table i have various dept's like a,b,c and i
have 2,3,4 emp id's in my dept table.I joined with these 2
tables.I want the results for equi join means how many
records will fetch.In the same scenario i have to know the
left outer join, right out join and full outer join resuls
means how many records will come. can any body tell me the
answers

Question Posted / pavan.25reddy

1 Answers
5420 Views
IBM, I also Faced
E-Mail Answers

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have..

Answer / bharath

inner join :3 recorde
eno dept
2 a
3 b
4 c

leftouter join: 5records
1 NULL
2 a
3 b
4 c
5 Null

Rigt outer join: 3 records
2 a
3 b
4 c
Null d (if d is not assigned to any employee)

full outer join: 5records
1 Null
2 a
3 b
4 c
5 Null
Null d

Thank you.

Is This Answer Correct ?

35 Yes

0 No

Post New Answer

More Business Objects Interview Questions

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

2 Answers

what is local filter

2 Answers Cap Gemini,

What is sdlc in bo?

2 Answers

How can we acheive Correlated sub-query in Designer?

2 Answers Infosys, TCCX, Wells Fargo,

what is universe

4 Answers TCS,

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers

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

3 Answers HCL,

whats the diff between break and section

4 Answers TCS,

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers Honeywell,

What are the general issues in migration process?

3 Answers Deloitte,

4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers Accenture, Aegis,

How to change font color of values in hyperlinked columns?

4 Answers

For more Business Objects Interview Questions Click Here