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

How to generate sequence numbers using expression transformation?

1086

---

Sequence generator, when you move from develoment to production how will you reset

2031

---

which one is better performance wise joiner or look up

1087

---

difference between informatica 8.1.1 and 8.6

3675

---

Differences between connected and unconnected lookup?

1211

---

Explain about Informatica server process that how it works relates to mapping variables?

1071

---

What is a grid in Informatica?

1066

---

server hot-ws270 is connect to Repository B. What does it mean?

2559

---

How to generate sequence numbers?

1083

---

What is sequence generator transformation in informatica?

1074

---

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

1715

---

What is dimensional table? Explain the different dimensions.

1169

---

Explain about cumulative Sum or moving sum?

1037

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2046

---

How to elaborate powercenter integration service?

1129

---