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
- 1 Answers
- 4701 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
what will be the contents for a functional requirements specifications
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What are all difference between business objects 6.5 and xi r2?
Explain when to use local filter and when to use global filter?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What are the data types present in bo? What happens if we implement view in the designer and report?
What is the difference between condition & filter?
What are the join problems comes appart from loop,chasm & fan Traps
Explain what are the measure objects?
What is object stores?
