- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ODI 12c - Using PL/SQL Packages in mappings
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.