Answer Posted / krishna

select * from (select distinct name male from fm where
gender='male'),(select distinct name female from fm e
where gender='female');

select decode(gender,'female',name)female,decode
(gender,'male',name)male from fm ;

What is option by which we can run all the sessions in a batch simultaneously?

1149

---

Differentiate between sessions and batches?

1024

---

How to create a non-reusable instance of reusable transformations?

1136

---

Differentiate between a database and data warehouse?

1148

---

What are the differences between oltp and olap?

976

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

How many ways are there to create ports?

1336

---

Quickly characterize reusable change?

1127

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2175

---

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

1083

---

Explain load alternative records / rows into multiple targets - informatica

1161

---

Clarify the aggregator change?

1034

---

differences between service based and product based?

2020

---

Which are the different editions of informatica powercenter that are available?

1034

---

How many ways are there to do 'remove duplicate records in informatica'?

1021

---