Using variables for dynamic information

Let's see how we can use variables to process data dynamically.

Assigning a value to a variable

Before we can use a variable, we will have to make sure that a value has been assigned to the variable, as is the case with any programming language. There are multiple ways to assign a value, but in all cases the values will have to be assigned in a Package. The package steps defined in this chapter will have to be executed before the interfaces or model operations that make use of the variables.

When you drag-and-drop a variable in a Package, different actions will be available on the variable.

We will review here the different actions (or Types, as they are called in the tool) that allow us to get the variable value. As you switch from one type to the other, ODI will change the graphical representation of the variable in the Package so that you know what action is selected without having to look into the details of the step.

Setting a hardcoded value

The Set...