ODI12c Working with Variables in Load Plans FAQS

1. What are Load Plan Variables?

Load Plan Variables are project or global variables declared in the Load Plan editor. They:

·        Are automatically available in all steps

·        Pass their values to Load Plan steps at runtime

2. How are variable values passed to Load Plan steps?

·        At Load Plan startup, values are passed as startup parameters

·        At a step level, variable values can be overridden for that step and its child steps

3. Do Load Plans use default or latest variable values?

No. At startup:

·        Load Plans ignore default values and historized/latest values in the execution context

·        Values used are either:

o   Specified when starting the Load Plan

o   Set or refreshed within the Load Plan

4. How are variables used in steps?

·        Run Scenario steps → Variables are passed as startup parameters to the scenario

·        Case / When / Else steps → Variables can control conditional branching

5. How do you declare a Load Plan variable?

·        Open Load Plan Editor → Variables tab

·        Click Add Variable in the toolbar

·        In the Lookup Variable dialog, select the variable to add

·        The variable now appears in the Variables tab and in the Property Inspector of each step

6. How do step-level variables inherit values?

·        By default, a step inherits the variable value from:

1.     Its parent step

2.     The value specified at Load Plan startup

7. How can you override variable values for a step?

·        Open Load Plan Editor → Steps tab

·        Select the step in the Steps Hierarchy table

·        In Property Inspector → Variables, modify the variable:

o   Select Overwrite → Apply value for this step and all child steps

o   Set a new value in the Value field

o   Select Refresh → Refresh the variable from its query before executing the step (only for variables with a Select Query defined)

8. Which steps cannot have overridden variable values?

·        Else and When steps do not support variable value overrides

9. Why is managing variables important in Load Plans?

·        Ensures correct data is passed to scenarios

·        Enables dynamic control of execution

·        Supports conditional branching and parameterization