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
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is lookup transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can a transformation be made reusable?
Define sessions in informatica etl?
What does command task mean?
What are the types of schemas we have in data warehouse and what are the difference between them?
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
Why union transformation is an active transformation?
How do you update the records with or without using update strategy?
What is the commit type if you have a transaction control transformation in the mapping?
What is a stored procedure transformation?
What is the use of code page?
How would you join a node to the already existing domain?