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
- 6004 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / zer0
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 |
Post New Answer View All Answers
What do you mean by worklet?
What is update strategy transform?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are Dimensional table?
What are the modules in Power Center
How can we handle two sessions in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
can anyone explain me about retail domain project in informatica?
What is meant by incremental aggregation?
Where is metadata stored?
What are the new features of informatica 9.x at the developer level?
How can a transformation be made reusable?
wat are deployement groups in informatica, how it will be used for developers
How can one identify whether mapping is correct or not without connecting session?
can we override a native sql query within informatica? Where do we do it?
