Forum Stats

  • 3,815,688 Users
  • 2,259,067 Discussions


Looping in ODI Load Plan

3673816 Member Posts: 79
edited Aug 20, 2018 5:38AM in Data Integrator


Does anybody know if it's possible to do a loop in an ODI Load Plan?

I would like to execute a scenario n number of times in a Load Plan, where "n" is going to be looked up as a refresh Load Plan variable, when the Load Plan runs.

Thank you



  • Adrian_Popescu-Oracle
    Adrian_Popescu-Oracle RomaniaPosts: 1,976 Employee
    edited Aug 16, 2018 4:07PM

    Hi Boris,

    In a package you can launch the execution of a Load plan using the OdiStartLoadPlan tool.

    You can also implement loops using variables, in a very simple way.

    So I recommend to test this approach.


  • 3673816
    3673816 Member Posts: 79
    edited Aug 16, 2018 4:18PM

    Thank you Adrian.

    I am looking at some other options, yours included.

    The other options will be somewhat of a "work-around" to what would have been the most desirable and straight forward approach - a loop right within the Load Plan itself. But it looks like that's unfortunately not possible.

    The other options will work, though.

    Thanks for your continued feedback. It's very helpful.


  • Shiv_Kumar
    Shiv_Kumar Member Posts: 148
    edited Aug 20, 2018 5:38AM

    Hi Developer,

    You can use below link to set up your requirement. I had also got one request where I needed to process multiple files in one target table sequentially with one interface and loop in package, kindly let me know if it was helpful

This discussion has been closed.