Answer / rkumar.etl

use user defined join option.

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

what we require for D.modelling?

1 Answers  

---

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

What is aggregate awareness?

1 Answers  

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---

what is parameter file?

1 Answers   Cap Gemini,

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---