Answer Posted / arunakumaril

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

(variableports)curr_col1_val:column1

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

(variableports)pre_col1_val:column1

What differs when we choose the sorted input for aggregator transformation?

1069

---

What are connected or unconnected transformations?

1171

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1160

---

How can informatica be used for an organization?

1270

---

What is workflow manager?

1098

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1157

---

How to update source definition?

1138

---

What is a code page?

1216

---

How can one identify whether mapping is correct or not without connecting session?

1493

---

What is decode in static cache?

1257

---

What is native users?

1217

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1076

---

Performance tuning in UNIX for informatica mappings?

2620

---

Explain in detail scd type 2 through mapping.

1087

---

How do you set a varible in incremental aggregation

1939

---