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

Where do we use mapping variables in informatica?

1013

---

What are the guidelines to be followed while using union transformation?

1084

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6949

---

Whats there in global repository

1652

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2014

---

Explain the different dimensions.

923

---

What are the tasks that can be performed using sq?

1042

---

Enlist some properties of sessions.

1035

---

What is the procedure for creating independent data marts from informatica 7.1?

1022

---

What is DR strategy for Informatica project?

1128

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2223

---

What are the main issues while working with flat files as source and as targets ?

1114

---

Is there any way to read the ms excel datas directly into informatica?

993

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2241

---

Sequence generator, when you move from develoment to production how will you reset

1965

---