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

Different circumstance which drives informatica server to expel records?

1041

---

Performance tuning in UNIX for informatica mappings?

2623

---

Where do we use mapping variables in informatica?

1118

---

What is expression transformation?

1144

---

Explain the scenario which compels informatica server to reject files?

1207

---

In development project what is the process to follow for an etl developer from day1

1758

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1165

---

What is the difference between a connected look up and unconnected lookup?

1000

---

How can you generate reports in informatica?

1081

---

what is the complex transformation you used in informatica

2623

---

How do you set a varible in incremental aggregation

1939

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7586

---

Do you find any difficulty while working with flat files as source and target?

1146

---

What is difference between a gateway node and worker node?

1202

---

Explain the informatica workflow?

1125

---