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
- 6018 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 do we implement materialized view?when to use materialized view?
What is the difference between informatica 7.0 and 8.0?
what is scd?
What are the types of data warehouses?
When will you use SQL override in a lookup transformation?
Define pmcmd command?
how i will stop my workflow after 10 errors
Explain direct and indirect flat file loading (source file type) - informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the tasks that source qualifier perform?
How can u stop a batch?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
Teradata 
