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
- 6082 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 are the deliverables?in your project?
difference between informatica 8.1.1 and 8.6
Is there any target staging area in informatica not staging area
How can we delete duplicate rows from flat files?
Explain the different lookup methods used in informatica?
Enlist the tasks for which source qualifier transformation is used.
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
What do think which one is the better joiner or look up?
What differs when we choose the sorted input for aggregator transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
Separate from an archive server and a powerhouse?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
State the limitations where we cannot use joiner in the mapping pipeline?
Design time, run time. If you don't create parameter what will happen
what is index?how it can work in informatica
