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 / annu
select decode(gender,'female',name) FEMALE,
decode(gender,'male',name) MALE from src;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain how to import oracle sequence into informatica?
generate date / time dimension in informatica
What is decode in static cache?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
In informatics server which files are created during the session rums?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are mapplets? How is it different from a Reusable Transformation?
explain one complex mapping with logic? sales project?
server hot-ws270 is connect to Repository B. What does it mean?
what are 3 tech challenges/ common issues you face?
What all are steps in up gradation of Informatica server?
What is blocking transformation?
How to load a Dimension ? and how to load a fact table?
What is sq transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance