Random Pentaho (PDI) Stuff - I

Pentaho PDI 5.0

1. Transformation components - Merge Join & Group By require sorted data. Use Sort rows component to sort the data. Alternatively if any of these components are used immediately after table input, then sort the data in table input query.
2. Multiway Merge join - As of version 5.0, this component doesn't work when connected to repository.
3. Spoon.bat - Edit this file to increase java memory. Default configuration : PENTAHO_DI_JAVA_OPTIONS="-Xmx512m" "-XX:MaxPermSize=256m" 

You can increase the highlighted values as per system configurations.