LOAD PLANS

    An ODI load plan  is an executable object in ODI that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. The leaves of this hierarchy are Scenarios. Packages, interfaces, variables, and procedures can be added to Load Plans for executions in the form of scenarios.

Go to Topology  a physical architecture agents

Double click on agent which you created.

Select test option

If pop up comes as test successful, means agent is configured to your context.

If not, do the process in cmd.

Go to load plans and scenarios, and click on new load plan.

 

Enter the name of your load plan as shown below..

Now save the load plan.

After creating load plan go to steps option ,  it looks as below with default root step.

From that we can generate branches.

 

 

 

Click on plus button , there we can see list of options  as serial step, parallel,and other ones..

If we select serial step, means the objects in that step are executed sequentially..

Click on serial step as below…

Now the serial step is added. Now we  can drag and drop actual objects(means packages,mappings,procedures) to it.

Note: if we drag actual objects also, load plan does not take directly those objects.it will take only scenarios of those objects.

If we create scenario’s for those objects , it will take otherwise it internally creates the scenarios and take.

In below , mapping is dragged, but we won't created scenario.

 

Here we can able to see mapping scenario in load plans and scenarios section .

Drag other mapping also as shown above..

 

Now we can see scenarios clearly in section as above..

Next, parallel step….

 

Here I created scenario for the package object manually as below..

 

Now the scenario is generated..

We dragged  2 packages to parallel step as below..

 

 

Now start run load plan as below..

Load plan starts running ..

We can able to see session list  how the load plan will going to run.. 

 

Now, case step  : it is just like if else block …

It requires one variable, so we generate as below and give the value as 10.

Go to variables there we can see the list of variables , select the variable for load plan

 

The variable is visible as below.

 

 

Now select case step as below…

select the variable,

Now we can able to see two more steps when and else which is present only in case step option.

 Select when step and give set some condition and drag some objects .  Here,  we dragged one mapping.

 

Now select else step and drag we dragged other mapping ..

In case step , if the condition is true then only the when step executes , other wise else step executes.. 

Here when step executes because the value in the variable and value here we gave satisfies…

Scheduler:

Go to load plan which we create.

Click on it .There we can see scheduling..

 

 

Give logical agent and give time to schedule as above..

Now go to your physical agent , and select update schedule and select your work repository name there and then click ok..

Now if we select view schedule , we can able to see the scheduled load planner.

 

At our scheduled time the session will going to starts as below.