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

How to elaborate powercenter integration service?

0 Answers  

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---

explain about session partitions ?

1 Answers  

---

---

what is diff between grep and find

3 Answers   IBM, iFlex,

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

What is operational data source (ODS)?

7 Answers  

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

What is the function of aggregator transformation?

0 Answers  

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---