Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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


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 dashboards? what is metrics?

7 Answers   TCS,

what r the disadvanges in boxir2

3 Answers   Accenture,

what r the advantages of creating the universe?

2 Answers  

What are the steps to taken care to improve the Report performance?

3 Answers  

I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance

5 Answers   TCS,

WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?

2 Answers  

Which versions are used in the bo dashboard work?

0 Answers  

What is the use of AFD? Where it can be stored?

1 Answers  

Tell me about linked universe ?

5 Answers   Tech Mahindra,

What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,

How to schedule the report in b.o?

0 Answers  

Give some information on report bursting?

0 Answers  

For more Business Objects Interview Questions Click Here
Categories