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.

Explain the types of lookup transformation?

0 Answers  

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

What is the need for an etl tool?

0 Answers  

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

---

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

How the informatica server increases the session performance through partitioning the source?

1 Answers  

---

What is the function of look up transformation?

0 Answers  

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---

How can you run a session without using server manager?

1 Answers  

---

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

what is INFORMATICA TESTING process

0 Answers  

---