Answer / santosh kumar sarangi

select city,max(decode(gender,'male',no)) as male,
max(decode(gender,'female',no)) as female from table_name
group by city

Answer / gagan

Suppose first table as test created below create table test
(
city varchar2(50),
gender varchar2(50),
nmbr varchar2(50)
)

and keep all data in it as mentioned and then try to run
this query...


select a.city, a.nmbr as male, b.nmbr as female
from test a, test b
where a.gender = 'male' and b.gender = 'female' and b.city
= a.city

Answer / gagan

Suppose first table as test created below...

create table test
(
city varchar2(50),
gender varchar2(50),
nmbr varchar2(50)
)

and keep all data in it as mentioned and then try to run
this query...


select a.city, a.nmbr as male, b.nmbr as female
from test a, test b
where a.gender = 'male' and b.gender = 'female' and b.city
= a.city

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

Without source how to insert record to target?

6 Answers  

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

Explain the flow of data in Iinformatica?

1 Answers  

---

What are the restrictions of union transformation?

0 Answers  

---

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

---