kettle Variable type kettle variable is divided into: 1. The environment variable is set by the set variables component, which can range from: JVM variables, job variables, parent job variables, root job variables. To refer to a variable by ${var} or%%var%% variable 2. The property file variable is set in the Kettle.property file under the. Kettle directory , and can be referenced in Kettle 3. Command-line arguments (equivalent to positional parameters) Command-line arguments are parameters that are passed in the pan when the transformation is performed, and can be used in SQL. Placeholder, also called positional parameter
Note: Either parameter can be represented in SQL with ${var} or%%var%%
Second, set the variable 1. Set the environment variable job:
To edit a set variable component:
Transformation:
Table Input:
2. Set properties file variable edit C:\Users\ user name \.kettle directory kettle.properties file, write: customernumber=124
Then restart the spoon (kettle) Conversion:
Table Input:
3. Set command-line argument variable conversions:
To obtain System information:
Table Input:
From for notes (Wiz)
Kettle Setting variables