Perform the following steps to set up the
parameter pushdown optimization:
- Open the Data Service window, then click the Parameter Pushdown tab.
- In the WHERE Clause Column, click in a cell and enter the Data Service Field name from the existing fields listed. The Data Service Field name is the virtual table field name in your WHERE clause. Press ENTER. Possible values are defaulted for Transformation Parameter and Value Format.
- Adjust the name of the Transformation Parameter as needed. The name is something that you create; it must be unique in the data service. Type the name in the Transformation Parameter field or in the window transformation properties. (The parameter is created in the transformation properties or is something you specify in a field).
- If needed, add a prefix or suffix to the default %s in Value Format field. For example, if you want to format a value, consider using [value]=%s. In most cases, the default %s is sufficient formatting.
- Save the optimization and exit the window by clicking OK.
- Run an optimization test.
- Publish a Pentaho Data Service.