Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5241 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
Explain when we use aggregate awareness function in designer?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
what are the day to day activities of BO administrator ?
What is the dense rank?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to schedule the report in b.o?
in sap bi we have wad, then why we go for sap bo
What are the steps to be taken to schedule the report?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
what is universe null
When to use local filter and when to use global filter?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain difference between zabo and webi?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
