ODI, Oracle Fusion, Scheduling

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.
New Plan
  • 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.
Scenario Selection
  • 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.
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.
Scheduling
  • 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.
Repetitions & Cycles
  • Go to Topology tab-> Physical Architecture-> Agents.
  • Right click on agent name and select ‘Update Schedule’ to activate the plan schedule.
Update the 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...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

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

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

1 thought on “Load Plan Creation and Scheduling in ODI”

Comments are closed.