Load Plan Creation and Scheduling in ODI

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..