Answer Posted / viswanath

Lookup transformation from Informatica 9x version can be
configured as an Active Transformation...
To use this option, while creating the transformation, we
must configure the Lookup transformation property "Lookup
Policy on Multiple Match" to Use All Values. Once created
we cannot change the mode between passive and active. When
ever the Lookup policy on multiple match attribute is set
to Use All Values. The property becomes read-only.

However, this is not possible for an Unconnected Lookup. We
may have to use the same old procedure of returning single
value by conctinating the required fields by a delimiter..

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1171

---

Please let me know how to make encryption and decryption with example?

1902

---

What's the layout of parameter file (what does a parameter file contain?)?

2386

---

What is DR strategy for Informatica project?

1190

---

How do you take back up of repository?

1162

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2067

---

without table how to come first record only in oracle?

2256

---

Which is the t/r that builts only single cache memory?

1190

---

What do you mean by blocking transformation?

1041

---

Write the advantages of partitioning a session?

1282

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

---

Why filter transformation is an active one?

987

---

Differentiate between sessions and batches?

1018

---

What is blocking transformation?

1145

---

design of staging area?

2030

---