Calling ODI Load Plan from another Load Plan

There is a requirement where  load plan execution has to wait till the first load plan execution completion.Basically second load plan has to check previous load plan an if that execution completed then it has to be triggered.

We can accomplish this by calling second load plan from first load plan end of the steps.So that as a last step second load plan will be triggered and first load plan will be completed before it get kicked off.

Let see how it can be doable.

1.Create a scenario to call the Second load plan.
2.Add above created scenario in the first load plan (as a last step)

We have to use “OdiStartLoadPlan” utility to call the load plan inside the ODI package.

1.Create a package

Sample example

Add "OdiStartLoadPlan" utility into the package and provide all the necessary details
Load Plan Name : Which load plan you supposed to trigger (Here we are calling load plan named "SecondLoad")
Context Code: Select  appropriate context from drop down
Agent Code: Select appropriate agent from drop down
Physical Agent: Select appropriate Physical agent from drop down
ODI User: Provide username with whom it should be kicked off
ODI Password: Provide password for above user
Loglevel: Set log level to track the session details


And Generate a Scenario for the above package.

2.Add the above scenario to the first load plan as a last step .

3.Now execute "FirstLoad" load plan and you can notice "SecondLoad" LP triggered as soon as First LP gets completed .