...
Item | Description |
|---|---|
system date (variable) | System time, changes every time you ask a date. |
system date (fixed) | System time, determined at the start of the transformation. |
start date range (Transformation) | Start of date range, based upon information in ETL log table. See, also .08 Transformation Settings. |
end date range (Transformation) | End of date range, based upon information in ETL log table. See, also .08 Transformation Settings. |
start data range (Job) | Start of date range based upon information in the ETL log table. See also .08 Transformation Settings. |
End date range (Job) | End of date range based upon information in the ETL log table. See also .08 Transformation Settings. |
Yesterday 00:00:00 | Start of yesterday. |
Yesterday 23:59:59 | End of yesterday. |
Today 00:00:00 | Start of today. |
Today 23:59:59 | End of today. |
Tomorrow 00:00:00 | Start of tomorrow. |
Tomorrow 23:59:59 | End of tomorrow |
First day of last month 00:00:00 | Start of last month. |
Last day of last month 23:59:59 | End of last month. |
First day of this month 00:00:00 | Start of this month. |
Last day of this month 23:59:59 | End of this month. |
First day of next month 00:00:00 | Start of next month. |
Last day of next month 23:59:59 | End of next month. |
copy of step | Copy nr of the step. See also Launching several copies of a step. |
Transformation name | Name of the transformation. |
Transformation file name | File name of the transformation (XML only). |
User that modified the transformation last |
|
Date when the transformation was modified last |
|
Transformation batch ID | ID_BATCH value in the logging table, see .08 Transformation Settings. |
Parent job batch ID | The PDI batch ID of the parent job taken from the job logging table. You need to enable logging in the job and set "Pass batch ID" in the job settings. |
Hostname | Returns the hostname of the server. |
IP address | Returns the IP address of the server. |
Command line argument 1 | Argument 1 on the command line |
Command line argument 2 | Argument 2 on the command line |
Command line argument 3 | Argument 3 on the command line |
Command line argument 4 | Argument 4 on the command line |
Command line argument 5 | Argument 5 on the command line |
Command line argument 6 | Argument 6 on the command line |
Command line argument 7 | Argument 7 on the command line |
Command line argument 8 | Argument 8 on the command line |
Command line argument 9 | Argument 9 on the command line |
Command line argument 10 | Argument 10 on the command line |
Kettle version | Returns the Kettle version (for example, 2.5.0) |
Kettle Build Version | Returns the build version of the core Kettle library (for example, 13) |
Kettle Build Date | Returns the build date of the core Kettle library |
Current process identifier (PID) | The PID under which the Java process is currently running |
...