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 do you handle two sessions in Informatica

669

---

What is the difference between informatics 7x and 8x and what is latest version?

547

---

can we override a native sql query within informatica? How do we do it?

652

---

What do think which one is the better joiner or look up?

726

---

wat are deployement groups in informatica, how it will be used for developers

1255

---

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

553

---

According to his methodology what all you need before you build a datawarehouse

1186

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3450

---

What is main use of mapplet?

658

---

How does a rank transform differ from aggregator transform functions max and min?

671

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9166

---

What is a repository manager?

648

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1764

---

Briefly define a session task?

592

---

Explain about cumulative Sum or moving sum?

620

---