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
- 5922 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 |
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
Under what condition selecting sorted input in aggregator may fail the session?
in what type of scenario bulk loading and normal loading we use?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
Can we call a stored procedure from a unix script which is run using command task
How many number of sessions can one group in batches?
why do u use shortcuts in informatica.?
what is distinct
what is target load plan
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
Teradata 
