Answer Posted / sudhar

Pushdown optimization is used to push the complex logic to
the database level. This will reduce the complexity of the
Powercenter mappings and increases the performance.

How can you differentiate between powercenter and power map?

1136

---

How can we update a record in the target table without using update strategy?

1199

---

What is parallel processing in informatica?

1783

---

What are the restrictions of union transformation?

1084

---

Could you explain what is enterprise data warehouse?

1220

---

Differentiate between sessions and batches?

1062

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1148

---

explain about unit testing? in real time?

2260

---

What are the designer tools for creating transformations?

1155

---

what is unit testing?tell me proceedure

2270

---

Define joiner transformation?

1099

---

Mention a few design and development best practices for informatica?

1042

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1187

---

what is mean by complex business rule ?

2215

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1134

---