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

Repository user profiles

1762

---

can you please explain me pre session and post session options?

7562

---

Separate from an archive server and a powerhouse?

961

---

In warehouses how many schemas are there?

1070

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1077

---

What is a stored procedure transformation?

1052

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2322

---

What's the layout of parameter file (what does a parameter file contain?)?

2383

---

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

1130

---

Explain sessions?

1053

---

Tell me about MD5 functions in informatica

929

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131

---

How to join three sources using joiner?

1105

---

Is it possible to create multiple domains on a single Informatica server?

1239

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1263

---