select male,female from (select row_number() over (order by (select 1)) as

following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target

male female
ram ramya
david deesha
kumar

any body give solution above question?

Question Posted / rakesh ameta

4 Answers
8321 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / rakesh ameta

select male,female from
(select row_number() over (order by (select 1)) as ID,names as male from gen where genders='male') a
FULL join
(select row_number() over (order by (select 1)) as ID,names as female from gen where genders='female') b
on a.id=b.id

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a node in Informatica?

1028

How are indexes created after completing the load process?

1622

How to generate sequence numbers using expression transformation?

1074

where to store informatica rejected data?

1080

Explain dynamic target flat file name generation in informatica

1036

Define pmcmd command?

1028

What is data movement mode in Informatica and difference between them?

1118

What is a dimensional model?

963

What is the reusable transformation?

1035

explain about unit testing? in real time?

2181

What is meant by LDAP users?

1174

what is song in infrmatica...?

2218

In warehouses how many schemas are there?

1059

What is standalone command task?

1306

What is the difference between informatics 7x and 8x and what is latest version?

1071