Answer / sam

Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

How would you copy the content of one repository to another repository?

0 Answers  

---

Insert else update option in which situation we will use

4 Answers   HCL,

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

in performance wise union is past,union all is past

2 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

---

Differentiate between router and filter transformation?

0 Answers  

---

Explain sessions and how many types of sessions are there?

0 Answers  

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

What is A cache?

2 Answers  

---