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
- 12513 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 the informatica workflow?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How do you manage the Parameter files while migrating your data from one environment to another environment?
tell me 5 session failure in real time how can you solve that in your project?
How to delete duplicate row using informatica?
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
Explain the mapping variable usage example in informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to update source definition?
tell me the rules and responsblites in our project(my project is development)
What is fact table? Explain the different kinds of facts.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How might you approve all mappings in the archive all the while?
What are roles and groups and benefits of using them?
What is native users?
