following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
Answer Posted / koti
by using expression transformation U can apply decode
function..
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How many dimensions are there in informatica?
What is xml source qualifier transformation in informatica?
What is a router transformation?
how we can load rejected record's at run time?(not through bad files)
What are the various types of transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
During the running session, output files are created by informatica server. Enlist few of them.
How to elaborate powercenter integration service?
How do you load only null records into target?
Why union transformation is an active transformation?
How is union transformation utilized?
Why is sorter an active transformation?
What are the mapping parameters and mapping variables?