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.

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

what is dynamic cashe

3 Answers   Informatica,

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---

What is target designer and target load order?

0 Answers  

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

Can you generate reports in Informatcia?

1 Answers  

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

Differentiate between Load Manager and DTM?

0 Answers  

---

Describe data concatenation?

0 Answers  

---

what is casual dimension?

6 Answers   IBM,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---