Tip: Prompting Variables in ODI 11g

Sometimes you may need to ask the user to input a value for your variable.
You can do it in ODI 11g by first declaring your variable and then placing it in a package using the option Declare.

Then create a scenario of the package and set the variable as input parameter.

When you execute the scenario, you will  be prompted for the variables you selected.