What is some common best practice on using PL/SQL Packages in ODI 12c mappings?
I have a FILTER in my mapping that uses a function value inside PL/SQL Package:
... WHERE xyz NOT IN (package_name.function_name)
I was thinking about defining a ODI variable that will SELECT that value from package_name.function_name and then execute it before the mapping runs in the Begin Mapping Command.
I'm not sure if this is a best 'practice thing' to do, so I'm willing to hear from you your opinions about this situation.