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
- 12319 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
Why do you use Mapping Parameter and mapping variable?
What are the databases that informatica can connect to windows?
What do mean by local and global repository?
How identifying bottlenecks in various components of informatica and resolving them?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
According to his methodology what all you need before you build a datawarehouse
Difference between Data and Index Caches?
what is the Default Source Option For Update Strategy Transformation?
Define filter transformation?
what is INFORMATICA TESTING process
Can we create a Integration service without a Repository service and vice versa?
How to delete duplicate row using informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the sequence generator transformation in informatica?
Enlist the various types of transformations.
