1 Reply Latest reply: Jul 16, 2013 3:39 AM by DecaXD RSS

    Solution Needed for ODI function call


      Hi Experts,


      I am using ODI 11g.

      Currently i am using oracle procedures to call a function in ODI .

      just like "Select package_name.function_name from dual " i am using this query in ODI variables.The output of the function
      i am using in ODI mails .

      So for this ..Suppose for any changes i need to go to the Oracle package and change the function logic...and then promote this
      to production ..which is a time taking for me.


      So i want to write this Function inside ODI variable and send the output to ODI mail ...So that i dont need DB side to promote
      the code to production on every changes.

      Please let me know whether this solution is good or not.


        • 1. Re: Solution Needed for ODI function call



          under my opinion is good having all the logic inside ODI. But it depends from the complexity of the logic and the frequency of your change. If you change the logic once for year it's quite useless make this inside your ODI.

          A good compromise could be to put a package_name.function_name step in your package.