Skip to Main Content
Forums

ODI 12c - Using PL/SQL Packages in mappings

kovarJan 7 2018 — edited Jan 8 2018

Hi everyone!

What is some common best practice on using PL/SQL Packages in ODI 12c mappings?

package.png

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.

Thanks,

- kovar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Feb 5 2018
Added on Jan 7 2018
#business-intelligence-applications, #data-integrator, #mapping, #system-management-and-integration
2 comments
353 views