following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
Answer Posted / abhishek kumar
src->sq->exp->filter->tgt
expression t/f
flag ->
iif(gender='male','female','male')
abhishek guddu
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How many number of sessions can one group in batches?
What is a stored procedure transformation?
What is a filter transformation?
Define pmcmd command?
What are the mapping parameters and mapping variables?
How to elaborate powercenter integration service?
Explain load alternative records / rows into multiple targets - informatica
what is the hint? how to use it to reduce the query processing in program?
In which transformation you cannot drag ports into it?
Differentiate between sessions and batches?
Make a note of the quantity vaults made in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is workflow? What are the components of workflow manager?
What are the advantages of using informatica as an etl tool over teradata?