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 is parallel processing in informatica?

1040

---

Explain the tuning lookup transformation - informatica

623

---

How is union transformation utilized?

578

---

What are the tuning techniques you applied during your last project

1575

---

What is session task and command task?

660

---

---

How to create Target definition for flat files?

768

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1329

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1643

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1266

---

can we override a native sql query within informatica? Where do we do it?

639

---

what is degenerated dimension?

3169

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1984

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

567

---

What are multi-group transformations?

573

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

686

---