Answer Posted / prabhu

After you tune the application, databases, and system for
maximum single-partition performance, you may find that the
system is under-utilized. At this point, you can configure
the session to have two or more partitions.

You can use pipeline partitioning to improve session
performance. Increasing the number of partitions or
partition points increases the number of threads.
Therefore, increasing the number of partitions or partition
points also increases the load on the nodes in the
Integration Service. If the Integration Service node or
nodes contain ample CPU bandwidth, processing rows of data
in a session concurrently can increase session performance.


Prabhu
www.iskilltech.com

What is a repository? And how to add it in an informatica client?

1149

---

Explain constraint based loading in informatica

1096

---

Explain what is informatica metadata and where is it stored?

1051

---

What is decode in informatica?

1165

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1085

---

What is parallel processing in informatica?

1715

---

What are the differences between source qualifier and joiner transformation?

1062

---

Why filter transformation is an active one?

987

---

Different sorts of metadata that stores in the storage facility?

1012

---

Enlist the various types of transformations.

1058

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

What is mapplet in informatica?

1057

---

Define update strategy?

1230

---

What are the various types of transformation?

1180

---

What is incremental aggregation?

1086

---