Answer Posted / sridhar,informatica developer

normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full

Parameter and variable differences

2022

---

Can informatica load heterogeneous targets from heterogeneous sources?

1131

---

What is main use of mapplet?

1086

---

Tell me about MD5 functions in informatica

884

---

What is a standalone command task?

1150

---

can u give example for factless fact table

6476

---

What does cheating measurement mean?

1005

---

What is the format of informatica objects in a repository?

984

---

On which transformations you created partitions in your project?

1271

---

How can you define user defied event?

988

---

Explain the mapping variable usage example in informatica

1095

---

Explain pushdown optimization and types in informatica

1031

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5705

---

What the difference is between a database, a data warehouse and a data mart?

1097

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086

---