wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

How can you differentiate between powercenter and power map?

0 Answers  

---

Why we use partitioning the session in informatica?

2 Answers  

---

what is the size of your data warehousing?

0 Answers   IBM,

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

what is incremental aggregation ,with example?

2 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

Differnce between filter and router?

14 Answers   IBM,

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

How to display null values on a target & non-null values on a target?

3 Answers  

---