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 can you differentiate between powercenter and power map?

1031

---

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

1043

---

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. ?

1986

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2482

---

What are the tasks that source qualifier perform?

1045

---

differences between service based and product based?

1979

---

What are the differences between a connected lookup and unconnected lookup?

1027

---

How many ways are there to create ports?

1263

---

can u any challenge your project?

1977

---

what are the Methods For Creating Reusable Transformations?

1116

---

How to update a particular record in target with out running whole workflow?

1548

---

Define update strategy?

1132

---

Define sessions in informatica etl?

979

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1626

---

What is union transformation?

918

---