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
How to create Target definition for flat files?
What are the restrictions of union transformation?
Explain the difference between mapping parameter and mapping variable?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How do you set a varible in incremental aggregation
Did u used latest transformations of 8.6.0? for what?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the differences between source qualifier and joiner transformation?
what is the Default Source Option For Update Strategy Transformation?
Can we create a Integration service without a Repository service and vice versa?
What is the sequence generator transformation in informatica?
Performance tuning( what you did in performance tuning)
What does “tail –f” command do and what is its use as an Informatica admin.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a predefined event?