Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 8265 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
What are the components of Informatica? And what is the purpose of each?
Describe the impact of several join conditions and join order in a joiner transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
wat are deployement groups in informatica, how it will be used for developers
Explain lookup transformation is active in informatica
Explain the difference between a data warehouse and a data mart?
Briefly define a session task?
Can we get 1st record through Informatica(without sequence number).
Differences between version 7.x and 8.x.
How many ways a relational source definition can be updated and what are they?
What is meant by active and passive transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is lookup change?
How to start a workflow using pmcmd command?
