/
PDI One liners and quick tips

PDI One liners and quick tips

  • Certain steps (for example the 'Get File Names') require wildcard file names. You sould supply a regex for the file names,  for example ".*\.csv$"
  • The Properties input step is able to resolve variables within the file before loading the data onto the stream. For example, if you have the following lines in your properties file:
       ROOT_DIR=/my/dir/
       LOG_DIR=${ROOT_DIR}/logs
    you can resolve LOG_DIR as /my/dir/logs by setting the 'Substitute variable for value'  checkbox in the Content tab of the Properties File dialogue.

Related content

PDI Performance tuning check-list
PDI Performance tuning check-list
Read with this
How to Configure Kettle's Spoon for a Pentaho Solution
How to Configure Kettle's Spoon for a Pentaho Solution
Read with this
Helpful Tips and Tricks Using Kettle
Helpful Tips and Tricks Using Kettle
Read with this
Running kettle transformation using Java
Running kettle transformation using Java
Read with this
Executing Job or Transformation packaged in a zip file
Executing Job or Transformation packaged in a zip file
Read with this
Pentaho Data Integration Articles
Pentaho Data Integration Articles
Read with this