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

How big was your fact table

1860

---

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

1206

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2348

---

What are the different options available for update strategy?

1049

---

what are the deliverables?in your project?

2194

---

What are the prerequisite tasks to achieve the session partition?

1295

---

What are the tasks that source qualifier perform?

1145

---

Explain the mapping variable usage example in informatica

1224

---

What are mapplets? How is it different from a Reusable Transformation?

1135

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1817

---

How many number of sessions can one group in batches?

1215

---

What are the popular informatica products?

1056

---

What can we do to improve the performance of informatica aggregator transformation?

1141

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1915

---

What is aggregate cache in aggregator transformation?

1201

---