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.

What is the benefit of session partitioning?

0 Answers  

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

---

Why we use lookup transformations?

1 Answers  

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

What do you mean incremental aggregation?

0 Answers  

---

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

---

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

---