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 is flashback table ? Advance thanks

1942

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7188

---

Different qualification between a related rotate toward the sky and isolates look upward?

990

---

What are the differences between oltp and olap?

972

---

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

2305

---

On which transformations you created partitions in your project?

1349

---

How to load the data from people soft hrm to people soft erm using informatica?

1021

---

What are the types of data warehouses?

1527

---

What do mean by local and global repository?

1226

---

What is domain in terms of informatica?

1009

---

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

1129

---

What is transformation?

1104

---

How to convert multiple rows to single row (multiple columns) in informatica

1384

---

how to load rows into fact table in data warehouse

1190

---

How can we update a record in the target table without using update strategy?

1150

---