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

There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 Answers  

Difference between drill by and drill across with example?

4 Answers   TCS, WNS,

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

0 Answers  

how can we overcome by loops?and also is it possible ,one user can different universe

4 Answers  

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 Answers  




Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 Answers  

what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,

how to coneect to a server in a business objects

1 Answers  

In banking domain how many Fact tables,Dimension table are present?

0 Answers   TCS, UST,

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,

How will you move reports from Dev to QA in BO

3 Answers   Infosys,

For more Business Objects Interview Questions Click Here
Categories