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 report template in b.o?

1 Answers  

can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

1 Answers   Accenture,

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.

3 Answers  

What is user docs and how to use this option in bo?

1 Answers   Bank of Baroda,

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1 Answers  

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  

how to create reports on screech?

1 Answers   Zensar,

How do you restrict access to rows of a database?

2 Answers  

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

define universe parameters?

5 Answers  

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

3 Answers   Accenture, Rolta, TCS,

For more Business Objects Interview Questions Click Here
Categories