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

How to generate or load values in to the target table based on a column value using informatica etl tool.

1062

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900

---

What are the static cache and dynamic cache in informatica?

1181

---

what is the Default Source Option For Update Strategy Transformation?

1233

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1105

---

Explain how many types of dimensions are available in informatica?

1094

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5669

---

Why do we need informatica?

985

---

How can we store previous session logs?

1068

---

How might one distinguish in the case of mapping is right or not without associating session?

1105

---

Difference between Target-based loading and constraint-based loading?

994

---

what is Active lock explain

2795

---

In warehouses how many schemas are there?

1070

---

tell me 5 session failure in real time how can you solve that in your project?

2290

---

What is the status code in stored procedure transformation?

1180

---