I suggest that you look at any of the many existing transformation methods that are installed by default. Your method is called automatically.

Hi,

Thanks for the update, would appreciate if possible to share any documentation related to the same.

This is all documented in the end-user documentation.

Thanks found the details in the documentation.

“For some scenarios it is not possible to map the target and source columns due to the fact that the source columns are not included in the target database view. You then have two options which both require some programming work. You can either extend the target view with the necessary columns or create a stored function that makes the actual key transformation. The name of the function should in this case be registered as the transformation method. Note that it should also hold the package name, e.g. My_Package_API.My_Transformation. It needs to be defined as a function that returns a string value. It also requires two values in parameters (strings); the Target Key Reference and the Service Name (in that specific order).”

Great, then you are now an expert! (few reads our documentation) :)