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
- 12321 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
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
Explain in detail scd type 2 through mapping.
What is an unconnected transformation?
How to Create a folder using pmrep command?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How many numbers of sessions can one group in batches?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How can a transformation be made reusable?
How to load last n records of file into target table - informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain the difference between mapping parameter and mapping variable?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Is stop and abort are same in informatica?
What is target designer and target load order?
What does “tail –f” command do and what is its use as an Informatica admin.
How to do unit testing in informatica? How to load data in informatica ?
