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 / krishna
select * from (select distinct name male from fm where
gender='male'),(select distinct name female from fm e
where gender='female');
select decode(gender,'female',name)female,decode
(gender,'male',name)male from fm ;
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Why sorter is an active transformation?
How many numbers of sessions can one group in batches?
What are the issues you have faced in your project? How did you overcome those issues?
How many number of sessions can one group in batches?
What do you understand by term role-playing dimension?
How can you generate reports in informatica?
How to update a particular record in target with out running whole workflow?
What is the difference between informatica 7.0 and 8.0?
What is the function of aggregator transformation?
In informatica workflow manager, how many repositories can be created?
What are the different types of olap? Give an example?
What do you mean by channel change?
How can a transformation be made reusable?
How would you copy the content of one repository to another repository?
What is dimensional table? Explain the different dimensions.