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   IBM,

---

WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?

2 Answers   PCS,

---

What is shortcut join?could give any one example?

8 Answers  

---

what is the difference between input file repository server and output file repository server ?

2 Answers   CTS,

---

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  

---

What are alertors in Business Objects?

5 Answers  

---

How can we acheive Correlated sub-query in Designer?

2 Answers   Infosys, TCCX, Wells Fargo,

---

How many universes can be created in a project?

0 Answers  

---

What is a category?

3 Answers  

---

what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,

---

how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,

---

How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,

---