lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

What is meant by query override?

0 Answers  

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

What is A complex mapping?

3 Answers   TCS,

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  

---

What is the difference between view and materialised view?

6 Answers  

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

---

daily how much amount of data send to production?

4 Answers   HSBC,

---