write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---

How the informatica server increases the session performance through partitioning the source?

1 Answers  

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

What is exclusive and normal mode for repository services?

0 Answers  

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

What is a connected transformation?

0 Answers   Informatica,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---