I have a requirement to enter the values in value mapping as specified below.
Source - Target
ABC - 123
DEF - 123
GHI - 456
But I am not able to enter two same values in the target, it's quite common to have more than one target values of same kind. Is there any way I can achieve this in Value mapping.
In that there is no need of entering 2 values.For your case source fields is different.There is no need of entering target once again.
Just add the source agency and source schema.
The logic is,
and DEF-source then target is 123.