Answer / rakesh

default is left outer join Dude you just make sure in transformer you joiin them based n the key, that's it

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

What is ds designer?

0 Answers  

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

what is repositery?

0 Answers   IBM,

---

Is it possible to query a hash file?

0 Answers   IBM,

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

How do you reject records in a transformer?

0 Answers  

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

how do u reduce warnings

1 Answers   CGI,

---

which memory is used by lookup and join

5 Answers   IBM,

---

Where the datastage stored his repository?

0 Answers  

---