Answer / purushotham perumalla

Create variable ports in Expression transformation to
concat name if the number is same as follows

Assume the input field names are number and name

define the variable ports in expression transformation in
the following order

v_flag = iif(number = v_number,0,1)
v_name = iif(v_flag = 1,name,v_name ||' '||name)
v_number = number
O_name = v_name

The output of o_name will be as follows

number o_name
----------------
101 raja
101 raja sekar
101 raja sekar reddy


Add an aggregator transformation after expression and group
by number. output number and o_name from aggr to target.
As aggr outputs last row in each group by deault it will
send 101 raja sekar reddy to the output.

Answer / lokesh y g

using dynamic lookup we can do it......

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

---

How will you update the row without using update statergy?

10 Answers   CTS,

---

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

2 Answers   Accenture,

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

what is scd?

6 Answers  

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

What do you mean by worklet?

0 Answers  

---

In warehouses how many schemas are there?

0 Answers  

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

---