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 to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2028

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2096

---

What are the components of workflow manager?

1085

---

What is the benefit of session partitioning?

1111

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1118

---

What is persistent lookup cache?

1026

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1114

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2257

---

what is the size of your data warehousing?

2091

---

What is rank transformation?

985

---

What is the status code in stored procedure transformation?

1180

---

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

1086

---

How does the aggregator transformation handle null values?

1144

---

What is union transformation?

961

---

What is the different lookup cache(s)?

1081

---