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.

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

In informatics server which files are created during the session rums?

0 Answers  

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

Why we use stored procedure transformation?

4 Answers  

---

What is metadata reporter?

1 Answers   Informatica,

---

how to use incremental load?

2 Answers   TCS,

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

How the facts will be loaded? explain

2 Answers   HCL,

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

What is A cache?

2 Answers  

---