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
- 5062 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 |
What is the difference between stop and abort in informatica
What is an incremental loading? in which situations we will use incremental loading
what is threshold error in informatica?
 Informatica Checkpoints
Using Expression transformation how to remove duplicate records from a relational source?
What are the different types of transformation available in informatica.
what is data driven in update strategy transformation?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is Performance tuning in Informatica?
how will you remove the duplicate records from flat file without using sorter?
Where should yoU place the flat file to import the flat file defintion to the designer?
Teradata 
