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
- 12631 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
How you prepared reports for OLAP?
State the limitations where we cannot use joiner in the mapping pipeline?
How many types of sessions are there in informatica.please explain them?
Differentiate between router and filter transformation?
How you can differentiate between connected lookup and unconnected lookup?
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 ?
What are the different versions of informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How many numbers of sessions can one group in batches?
What is dynamic cache?
Explain the features of connected and unconnected lookup.
What are junk dimensions?
How can we use batches?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How union transformation is used?
