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..

Why sorter is an active transformation?

1144

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1202

---

Difference between Data and Index Caches?

1106

---

Explian the Process of deployment groups in informatica

1003

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2077

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1911

---

What is meant by target load plan?

929

---

 Informatica Checkpoints

3277

---

What are the different versions of informatica?

1206

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1938

---

What are the types of schemas we have in data warehouse.

914

---

What are the popular informatica products?

969

---

Explain joiner transformation in informatica

1088

---

How to create Target definition for flat files?

1178

---

have u done any performance tuning? how u ll do?

2259

---