one to many mapping..
I have a requirement where one source field can be mapped to 3 fields.
If the values in the one field is say for eg. A, it should map to field 1 in target.
If it is 2 than it should map to Field2
if it is 3 should map to Field3
Else to nothing.
Is that can done using standard function or i have to used UDF.