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?
- 8 Answers
- 12498 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
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
Explain what is informatica metadata and where is it stored?
How to do unit testing in informatica?
How to partition the Session?
Where do we use mapping variables in informatica?
Explain in detail scd type 2 through mapping.
Explain incremental aggregation in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
In warehouses how many schemas are there?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are active and passive transformations?
What is substr in informatica?
what is the difference between informatica6.1 and infomatica7.1
What is the use of source qualifier?
Explain pmcmd command usage in informatica
What is Session and Batches?
