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 / anwar
select name,
decode(gender,'male','MALE',
'female','FEMALE')GENDER from sOURCE;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what is informatica metadata?
Explain sessions. Explain how batches are used to combine executions?
What are the types of presistent cache in look up tr.
What is the difference between informatica 7.0 and 8.0?
Target increases every day even though no new record was inserted
What is pmcmd command?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to do the error handling of if ur source is flatfiles?
Can anyone tell me the new features in Informatica 9 Version?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to load data in informatica ?
what are 3 tech challenges/ common issues you face?
Differentiate between source qualifier and filter transformation?
In which transformation you cannot drag ports into it?