Answer Posted / surendra kumar

Hi,

Lookup is both "Active" as well as "Passive"

Till informatica 8 it was only passive because one of its property "Lookup Policy on Multiple Match" has options of:
i)any values
ii)first values
iii)last values
iv)report error
So for each input record it will produce one output record either any corresponding matching value or Null. But number of Input row is equal to number of output row.

But from Informatica 9 onwards there is one addition in the option of "Lookup Policy on Multiple Match" is:
"Use All Values"
using this property one input row can give multiple output rows i.e number of input rows is not equal to number of output rows.

Thanks & Regards
Surendra Kumar

what is size of u r database?

2311

---

How many number of sessions can one group in batches?

1162

---

Explain incremental aggregation in informatica

1137

---

What are the different lookup cache(s)?

1123

---

Define mapplet?

1018

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2428

---

Make a note of the quantity vaults made in informatica?

989

---

How we can create indexes after completing the load process?

1163

---

what is mean by complex business rule ?

2163

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1067

---

how to create user defined function (udf) in informatica

1315

---

Does an informatica transformation support only aggregate expressions?

1049

---

Target increases every day even though no new record was inserted

1589

---

What is main use of mapplet?

1135

---

What is sq transformation?

1169

---