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
- 8381 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
Explain lookup transformation is active in informatica
What is the difference between informatics 7x and 8x and what is latest version?
What is meant by active and passive transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
tell me about your project functionality
How do you load alternate records into different tables through mapping flow?
Describe expression transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is song in infrmatica...?
Clarify the utilization of aggregator cache record?
What are the differences between joiner transformation and source qualifier transformation?
Briefly define reusable transformation?
Explain lookup transformation source types in informatica
What are the tasks that source qualifier perform?
