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
- 5958 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 are the different types of olap? Give an example?
What are different types of transformations available in informatica?
What are the tuning techniques you applied during your last project
Can anyone briefly describe abt audit table loading?
how we can update a target table without update strategy and update override?
What is target load order?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
what is diffrence b/w joner and union transfermation
permutations of mapplet
can we use bulk loading when we use look in mapping
What is aggregate cache in aggregator transformation?
what is the method of error handling when session is running?
Teradata 
