user defined function

[Former Member]

hi

Can anybody please give a simple real time example of a simple user defined function where we will use and the requirement for using the UDF.

regards

raghu.

[Former Member · Accepted solution]

Hi,

Check with this

Regards

Seshagiri

[Former Member]

Hi Raghu,

We use UDF in such cases when we r not having any standard function available in the graphical mapping.

And also sometimes a 2-3 line UDF is better than complex stadard function's due to performance issue.

Lets say u want to do a substring operation i.e u want to split a string into two then u can write a simple UDF.

also for sorting the input values u can use UDF.

if u want to trim or remove leading zeros .. then u can use UDF.

please search in SDN with keyword "UDF" u will get a lot of...

Please revert back if you havn't undersatnd yet.

Thanqs

Biplab

[nikhil_bose]

it depends on the scenarios.

generally speaking, if there is no/efficient built-in function to do a mapping, we go for UDFs

It is more flexible than using built-in ones

nikhiL