Answer / Adesh Kumar

A Sorter Cache in Informatica temporarily stores data in memory while sorting, improving performance by reducing the number of sort passes required. The cache holds the entire input dataset as it is being sorted, and once the sort operation is complete, the sorted data can be passed on to subsequent transformations without additional sorting.

explain abt joiner t/r?

1 Answers   IBM,

---

What is meant by lookup transformation? Explain the types of lookup transformation?

1 Answers  

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1 Answers  

---

In which scenario did you used pushdown optimization?

1 Answers  

---

In development project what is the process to follow for an etl developer from day1

1 Answers  

---

Is it possible to use a client with different version than that of its Informatica server?

1 Answers  

---

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

How are the sources and targets definitions imported in informatica designer?

1 Answers   Informatica,

---