Answer / rayudu

Connected lookup is used to lookup on each and every row
bjut unconnected lookup is used to lookup only when the
condition is true i,e unconnetcec is used only for selectetd
rows so obviously unconnected is faster .


Regards,
rayudu.

Answer / yamini

Performance wise unconnected look up transformation is better as it returns only one port and doesn't build any dynamic cache. Only static cache is build. It can be used any where in the mapping using LKP expression in another transformation.

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,

---

What is power center repository?

1 Answers  

---

How do you load first and last records into target table?

0 Answers  

---

Write the unconnected lookup syntax?

0 Answers  

---

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

---