Updated 16/06/2010
This guide has been tested and works with the latest version of Pentaho BI Server 3.6.
Pentaho 3.6 with MySQL, PostgreSQL & Oracle.
Posted under BI Server, Open Source, Pentaho, Tutorials
Using Variables (?) with Table Input Steps.
Posted under Data Integration, Open Source, Pentaho, Tutorials
Using arguments with Pentaho Data Integration (PDI) transformations are extremely handy when trying to pass through dynamic information. In this tutorial I will show how you can implement variables (denoted by ?) within SQL statements using Table input steps. Along with using variables I also cover how to copy and get rows from the result (memory), how to use system information and debugging steps. This tutorial was done with version PDI 3.2.0.