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 can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

What does reusable transformation mean?

0 Answers  

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

---

normalizer transformation

3 Answers   CTS,

---