Looping in ODI Load Plan

3673816

Hello.

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
Boris

Adrian_Popescu-Oracle

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.

Adrian

3673816

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.

Boris

Shiv_Kumar

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

http://odiexperts.com/multiple-files-single-interface/