Answer Posted / murali udayagiri

You can use the below query in SQ trans if the source is
relational, if not u can do it in expr trans.

select coalesce((case when gender='male' then ename
end),',')||','||
coalesce((case when gender='female' then ename
end),'###') "male,female" from temp_emp1;


Thanks,
Murali Udayagiri

What are the settings that you use to configure the joiner transformation?

1055

---

what is the difference between informatica6.1 and infomatica7.1

2280

---

What is union transformation in informatica?

1146

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2011

---

What does “tail –f” command do and what is its use as an Informatica admin.

1108

---

What do mean by local and global repository?

1226

---

Why update strategy and union transformations are active? Explain with examples.

1243

---

How to differentiate between the active and passive transformations?

1168

---

When do you use sql override in a lookup transformation?

1101

---

without table how to come first record only in oracle?

2257

---

What is dimensional table?

1069

---

What is joiner transformation?

1010

---

Explian the Process of deployment groups in informatica

1062

---

What is DR strategy for Informatica project?

1190

---

What is the use of an aggregator cache file?

1199

---