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 to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

How many ways you create ports?

1 Answers  

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

what is target load plan

2 Answers   Cap Gemini,

---

What is the sequence generator transformation in informatica?

0 Answers  

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

---

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---