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?
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
How to do the error handling of if ur source is flatfiles?
What is substr in informatica?
How many types of sessions are there in informatica.please explain them?
What is Data Caches size?
tell me 5 session failure in real time how can you solve that in your project?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is informatica metadata?
What is depict expression change?
What is flashback table ? Advance thanks
Quickly characterize reusable change?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain Dataware house architecture .how data flow from intial to end?
whats the logic to load the lower level of granularity of data to fact table.
Explain why we use partitioning the session in informatica?