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 happens when a session fails and you click on recover?

1172

---

Which files are created during the session rums by informatics server?

1233

---

What is a stored procedure transformation?

1113

---

how to load rows into fact table in data warehouse

1231

---

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

2654

---

What is intricate mapping?

1315

---

How to extract sap data using informatica? What is abap? What are idocs?

1253

---

Enlist the differences between database and data warehouse.

1166

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174

---

Differentiate between a database and data warehouse?

1194

---

design of staging area?

2076

---

If informatica has its scheduler why using third party scheduler?

1310

---

How does a sorter cache works?

1110

---

How do you set a varible in incremental aggregation

1945

---

Write the advantages of partitioning a session?

1335

---