Answer Posted / ankit kansal

There is only one row as per the defined problem. so first you have to break down this one row into multiple rows as separated by delimiter ','.
1|A
1|B
1|C
1|D
2|A...
Now in Expression Transformation using some string functions and later using rank/aggregator T/S you can achieve your result...

http://deepinopensource.blogspot.in

Explain lookup transformation source types in informatica

1151

---

How to update source definition?

1141

---

Explain the informatica workflow?

1127

---

How can we use batches?

1062

---

What is substr in informatica?

1261

---

Does an informatica transformation support only aggregate expressions?

1086

---

Where is metadata stored?

1192

---

Define enterprise data warehousing?

1257

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1799

---

What is lookup change?

1108

---

Tell me about Propagate functions in informatica

976

---

What is a dimensional model?

1033

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1343

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1676

---

What is the command used to run a batch?

1110

---