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
- 5030 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 facttable granularity?
What is a joiner transformation and why it is an active one?
What is union transformation in informatica?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
why dimenstion tables are denormalized in nature ?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
Is it possible to update the target table with PK?
explain abt joiner t/r?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
why we use materialized view over view?
How many ways a relational source definition can be updated and what are they?
Teradata 
