Write to log (step)

Description

This step writes information to the PDI logging system.

Options

Option

Description

Step name

Name of the step. Note: This name has to be unique in a single transformation

Log level

The logging level to use.
Note: Logging will occur in jobs or transformations run at any logging level at or above the level specified here. So, setting this value to Minimal will cause a log entry to be written in a job or transformation run in Minimal logging, Basic logging, Detailed logging, etc. logging levels, but NOT Nothing at all or Error logging only.

Print header

Whether or not the column names for data values is printed. In the example below, this value has been set to false, so only the actual values (3, 4) are printed.

Limit rows

Limit the number of rows given by the parameter "Nr. of rows to print" (available since version 5.0 GA)

Nr. of rows to print

The number of rows to print when option "limit rows" is checked (available since version 5.0 GA)

Write to log

The text to use in the logging line(s)

Fields

The data from fields that should we written to the log

Example log output

2013/01/24 12:30:52 - Write to log.0 -
2013/01/24 12:30:52 - Write to log.0 - ----------> Linenr 1----------------------------
2013/01/24 12:30:52 - Write to log.0 - test log
2013/01/24 12:30:52 - Write to log.0 -
2013/01/24 12:30:52 - Write to log.0 -  3
2013/01/24 12:30:52 - Write to log.0 -  4
2013/01/24 12:30:52 - Write to log.0 -
2013/01/24 12:30:52 - Write to log.0 - ====================
2013/01/24 12:30:52 - Write to log.0 -
2013/01/24 12:30:52 - Write to log.0 - ----------> Linenr 2----------------------------
2013/01/24 12:30:52 - Write to log.0 - test log
2013/01/24 12:30:52 - Write to log.0 -
2013/01/24 12:30:52 - Write to log.0 -  3
2013/01/24 12:30:52 - Write to log.0 -  4
2013/01/24 12:30:52 - Write to log.0 -
2013/01/24 12:30:52 - Write to log.0 - ====================