Answer Posted / vali

to improve the session performance we use the session
partitioning.it improves performance by giving multiple
connections to the source and target.

there are five types of partitioning the session
pass through
data base
round robin
key range
hash partitioning..

How does a rank transform differ from aggregator transform functions max and min?

1142

---

Explain lookup transformation source types in informatica

1039

---

What does refresh system mean, and what are its distinctive choice?

1070

---

Differentiate between sessions and batches?

962

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1791

---

What is the format of informatica objects in a repository?

972

---

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

1066

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1169

---

In which transformation you cannot drag ports into it?

1240

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1030

---

What is an expression transformation in informatica?

962

---

what is mean by complex business rule ?

2108

---

What is xml source qualifier transformation in informatica?

1173

---

How can we delete duplicate rows from flat files?

1161

---

what is Active lock explain

2724

---