on 2010 May 27 6:55 PM
Hi All,
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?
Regards
Faisal
Edited by: Abdul Faisal on May 27, 2010 11:26 PM
Hi
You can go with UDF. create a udf with the argument "str" and use the below code.
Source> UDF>Target
if(str.equals("AM")) {
return "Telus";
}else if(str.equals("LV")) {
return "TELUS US";
}else if(str.equals("MO")) {
return "Concentrix";
}else{
return "Telus";
}
Regards
Ramg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.