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

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

Define sessions in informatica etl?

0 Answers  

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

---

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---