Answer Posted / arunakumari l

(here column names are not mentioned .so,i have taken them
as column1 and column2)

take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.

STEP1:
use this below logic in expression transformation:-

(variableports)curr_col1_val:column1

(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)

(variableports)pre_col1_val:column1

STEP2:
Take groupby on column2 in aggregator

What are the new features of informatica 9.x developer?

966

---

How are the sources and targets definitions imported in informatica designer?

1097

---

Can you generate sequence numbers without using the sequence generator transformation?

1111

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1948

---

What are the types of lookup transformation?

1067

---

Plz can any one say me how to get the informatica certification materials and dumps

2042

---

What is meant by lookup transformation? Explain the types of lookup transformation?

943

---

Reusable transformation and shortcut differences

1838

---

What is the difference between stop and abort in informatica

1086

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1047

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1079

---

Is stop and abort are same in informatica?

995

---

How to update source definition?

1082

---

what is the difference between informatica6.1 and infomatica7.1

2267

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2740

---