Load Plans: Fancy term but what does it actually mean. Well, Load plan in ODI is an object which can be used to schedule single/multiple scenarios in series or parallel. So let’s see how to create a simple load plan:
Plan Creation
- In the designer tab, click on the icon to the right of ‘Load Plans and Scenarios’ and select ‘New Load Plan’. A new window opens.

- Give a Name to the load plan in the definition tab.
- Click on the + icon in the Steps tab and select ‘Run scenario step’. ‘Serial step’ and ‘Parallel Step’ can be selected if multiple scenarios need to be scheduled. A popup window opens.

- Select the appropriate scenario and click on Next.

- Select any additional declare variables if needed and click Finish.
- To pass values to declare variables, select the scenario step just created and go to properties window.
- In the Scenario variables section, provide the variable values.

Save it. Your plan is ready.
Plan Scheduling
Follow the below steps to schedule the Load plans:
- In Load plans and Scenarios, expand the load plan and right-click on scheduling. Select New Scheduling. A new window opens.

- Select the appropriate Context, Logical Agent and Log level.
- Select the schedule based on your requirement like Daily, Weekly, Monthly etc.

- If the plan needs to run multiple times, go to the Execution cycle tab.
- Select ‘Many times’ and give appropriate values as needed to ‘Maximum number of repetitions’, ‘Maximum cycle Duration’ and ‘Interval between repetitions’. Click on Save.

- Go to Topology tab-> Physical Architecture-> Agents.
- Right click on agent name and select ‘Update Schedule’ to activate the plan schedule.

- Click OK on the window that opens.
- Load plan is now activated.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
![]()
Related Posts:
ODI Reverse Engineering
How to create Oracle PL SQL Procedure in ODI
Web Service Invocation From ODI
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Check out the Amazon Deals of the day based on your interests..

1 thought on “Load Plan Creation and Scheduling in ODI”
Comments are closed.