Answer Posted / padmavathi

Joiner:
Can join herterogeneous sources.
Can join non-relational sources.
Can join partially transformed data.

Loopup:
Can reuse cache across session run.
Can reuse cache with mapping.
Can modify cache dynamically
Can query relational table or flat file.

Performance tuning( what you did in performance tuning)

2054

---

What is the difference between a connected look up and unconnected lookup?

1001

---

Can we create multiple integration service on single repository?

1240

---

What is blocking transformation?

1187

---

How many ways are there to do 'remove duplicate records in informatica'?

1064

---

What is joiner transformation in informatica?

1098

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1947

---

How to implement security measures using repository manager?

1234

---

Explain the aggregator transformation?

1221

---

Where do we use mapping variables in informatica?

1119

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1178

---

How do you load alternate records into different tables through mapping flow?

1926

---

how to create user defined function (udf) in informatica

1349

---

Enlist few areas or real-time situations where informatica is required.

1138

---

What are the new features of Power Center 5.0?

1846

---