Answer Posted / raghvendra

incremental aggregation performs aggregation on incremented
data..so based on requirements if we can use incremental
aggregation then definately it will improve performance..so
while develop mapping always keep in mind this factor too...

explain about unit testing? in real time?

1655

---

Performance tuning( what you did in performance tuning)

1483

---

What are data-driven sessions?

713

---

which one is better performance wise joiner or look up

620

---

What is the use of an aggregator cache file?

683

---

---

Write the program through which the records can be updated?

512

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1616

---

Please let me know how to make Data masking in informatica..

1265

---

Differentiate between reusable transformation and mapplet.

568

---

what is size of u r database?

1844

---

can we override a native sql query within informatica? How do we do it?

644

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

784

---

What is the use of transformation?

569

---

Is there any way to read the ms excel datas directly into informatica?

548

---

What is informatica metadata and where is it stored?

581

---