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?
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
Informatica Checkpoints
What are the components of the workflow manager?
How many dimensions are there in informatica?
differences between service based and product based?
Differentiate between a database and data warehouse?
What is olap (on-line analytical processing?
Separate from an archive server and a powerhouse?
Explain the code page compatibility?
Define update strategy?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Informatica settings are available in which file?
How many number of sessions can one group in batches?
How to configure mapping in informatica?
How to handle decimal places while importing a flatfile into informatica?
What is workflow monitor?