Answer Posted / rajesh.a

We need to use sorter,Expression and aggregator transformations to do this

1.Sort by ID
2.Take 2 variable ports one for id and one for name and store the values of id and keep on comparing with current id i.e variable is having previous id.
so,if previous id=current id then (variable name)||name otherwise only name.assign the variable name to output port
3.Use aggregator and use last or max(len(name)) to get the result

How many ways are there to do 'remove duplicate records in informatica'?

951

---

What does refresh system mean, and what are its distinctive choice?

1065

---

How can we create index after completion of load process?

1068

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9964

---

What is a sorter transformation?

1033

---

what are 3 tech challenges/ common issues you face?

2276

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1171

---

Is there any target staging area in informatica not staging area

2504

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1033

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1994

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1505

---

What is a connected transformation?

1041

---

can anyone suggest best free Talend data integration training online

1622

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1711

---

What are multi-group transformations?

1007

---