Answer Posted / chanti

Genrally, data base opertions are more faster than
operations that are excuted under power center.

The main idea behind pushdown optmization is to push some
of the transformation logic to either source side or target
side data base, so that performance can be improved.

Explain the code page compatibility?

1075

---

While migrating the data from one environment to another environment how would you manage the connections?

1092

---

What is a stored procedure transformation?

1059

---

What is the advantage of informatica?

1069

---

Explain the difference between mapping parameter and mapping variable?

1045

---

COM components can be used in Informatica

2398

---

What is the Process to creating lookup transformation in informatica

1048

---

How many number of sessions can one group in batches?

1163

---

What are the reusable transformations?

1170

---

What are the differences between joiner transformation and source qualifier transformation?

1179

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1135

---

How to update a particular record in target with out running whole workflow?

1585

---

Repository user profiles

1769

---

How you prepared reports for OLAP?

1600

---

What is the meaning of decode in informatica?

1123

---