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
5240 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

Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan

3 Answers

what r the advantages of creating the universe?

2 Answers

What is meant by ZABO and FC(full-client)?

2 Answers

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers TCS,

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

0 Answers

1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 Answers

What are the advantages of Xcelsius & Crystal reports over Infoview?

1 Answers Reliance,

What is ment by For each For all function. In which case we use the option in BO?

2 Answers IBM, TCS,

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

0 Answers ASD Lab, Wipro,

Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?

2 Answers

What are the join problems comes appart from loop,chasm & fan Traps

0 Answers IBM,

how u link universes of same functional domain ?

2 Answers Business Intelligence Analytics, IBM,

For more Business Objects Interview Questions Click Here