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

How many transformations can be used in mapplets.

1938

---

Scheduling properties,whats the default (sequential)

1960

---

How to do unit testing in informatica?

1177

---

Slowly changing dimensions, types and where will you use them

1717

---

What is aggregator transformation in informatica?

953

---

How to create the source and target database connections in server manager?

1091

---

Explain transaction control transformation in informatica

1272

---

What is mapping debugger?

1021

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1325

---

What is blocking transformation?

1151

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

What is sorter transformation?

1051

---

What you know about transaction control transformation?

996

---

list out all the transformations which use cache?

1187

---

what is the size of your data warehousing?

2096

---