Using named parameters

In the last exercise, you used two variables: one created in the kettle.properties file, and the other created inside of Spoon at runtime. There are still more ways to define variables. One of them is to create a named parameter. Named parameters are variables that you define in a transformation, and they can have a default value. You only have to supply a value if it differs from the default. Let's look at how it works, as follows:

  1. Open the last transformation (if you had closed it).
  2. Double-click anywhere in the work area excepting over the steps or hops. This will open the Transformation properties window.
  1. Click on the Variables tab. This is where we define the named parameters.
  2. Fill in the grid as shown, replacing ...

Get Pentaho Data Integration Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.