I have a field at source side as CREATED_BY which is need to map to CREATED at target side. I need the solution for below logic
if first 2 letters of CREATED_BY is AM
then CREATED = Telus
elseif first 2 letters of CREATED_BY is LV
then CREATED = TELUS US
elseif first 2 letters of CREATED_BY is MO
then CREATED = Concentrix.
if none of this condition is met the map with default value which is Telus.
Can anyone suggest me should I go for UDF or I can achieve the functionality by standard functions provide by message mapping. If it can be achieved by standard function then please provide complete the solution. Your help is highly appreciated
how to create UDF for above logic?
Edited by: Abdul Faisal on May 27, 2010 11:26 PM