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,

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

---

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

---

how many session run unix environment what command using ?

1 Answers   HCL,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

what is the predefined port in dynamic lookup

2 Answers  

---

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

---

what is semi-additive fact?where did u used?

2 Answers  

---