Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6014 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
The purpose of ur question is to update male to female and
female to male .......... is it so, then
Source --> SQ --> Expression --> Target
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)
make a output port say gender_new and give the value of
gender_check as output.Use gender_new as output to target.
Kindly revert if this worked.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
how to design mapping half of source table records into one target and remaining half into another target
difference between shortcut and reusable transformation?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
Explain the difference between mapping parameter and mapping variable?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
How to generate sequence numbers without using the sequence generator transformation?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
How are the sources and targets definitions imported in informatica designer?
how i will stop my workflow after 10 errors
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
According to his methodology what all you need before you build a datawarehouse
What are the components of workflow manager?
Teradata 
