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
- 12842 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
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is an aggregator transformation?
What are the advantages of informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Describe data concatenation?
What is a difference between complete, stop and abort?
How do you promote a non-reusable transformation to reusable transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a joiner transformation and why it is an active one?
server hot-ws270 is connect to Repository B. What does it mean?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to configure mapping in informatica?
Differentiate between reusable transformation and mapplet.
How to create or import flat file definition in to the warehouse designer?
