following table
source target
name gender name target
a1 male a1 female
a2 female a2 male
i want a1 female update to target how will do?
Answer Posted / kasi gaddam
Use an expression transformation and make 1 variable port
in it say gender_check, put the condition in it as
IIF(gender=male,female,male)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the informatica workflow?
What is a transaction control transformation?
Separate from a database, an information bazaar, and an information stockroom?
What are the differences between joiner transformation and source qualifier transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to improve the performance of a session using sorter transformation?
Can u generate reports in Informatica?
How to delete duplicate row using informatica?
Explain incremental aggregation in informatica
How you prepared reports for OLAP?
What are the modules in Power Center
What is the status code in stored procedure transformation?
Why sorter is an active transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is rank index in rank transformation?