If an ODI user function has one syntax and one or more implementations, can it be used in an ODI
interface mapping?
A.
Yes, but to be mapped in an ODI interface it also needs an ODI variable.
B.
No,it can only have one syntax and one implementation for all technologies.
C.
Yes,but you need to write a custom knowledge module.
D.
Yes, duringexecution, itwill substitute the specific technology implementation.
Explanation:
Answer D.
One key feature of the User Functions is that they will give you the opportunity to enter the matching syntax for any other database of your choice. No matter which technology you will use later on, you will only have to provide the name of the user function, irrespectively of the underlying technology.
To add other implementations and technologies, simply go back to the Implementation tab of the User Function, click the Add button. Select the technology for which you are defining the code, and add the code.