1. Preface…………………………………………………………………………………………………………………………… 4
2. 初学者的问题……………………………………………………………………………………………………5
2.1. Spoon启动的问题………………………………………………………………………………………………5
2.2. transformations 和 jobs的区别………………………………………………..5
2.3. Rule on mixing row ‘types’ on a hop in a transformation………………………………………………… 5
2.4. On duplicate fieldnames in a transformation………………………………………………………………….6
2.5. 关于空字符串和NULL………………………………………………………………………………………. 6
2.6. 在transformation中怎样复制一个field?…………………………………………………………7
2.7. How to do a database join with PDI?…………………………………………………………………………… 8
2.8. transformations怎样才能按顺序执行（这个4.0已经可以了）?………………………………………………………………………….8
3. 如何报告Bug，提新feature?………………………………………………………………………………………… 9
3.1. Preface……………………………………………………………………………………………………………………. 9
3.2. The links to click………………………………………………………………………………………………………..9
3.3. What to put in a bug report?……………………………………………………………………………………….. 9
3.4. What to put in a change request?………………………………………………………………………………..10
3.5. A word of thanks………………………………………………………………………………………………………10
4. 源代码的访问…………………………………………………………………………………………………………. 11
4.1. Windows……………………………………………………………………………………………………………….. 11
4.2. Linux……………………………………………………………………………………………………………………..11
4.3. Web SVN access………………………………………………………………………………………………………11
4.4. Eclipse……………………………………………………………………………………………………………………11
4.4.1. Subclipse………………………………………………………………………………………………………… 11
4.4.2. Creating patches………………………………………………………………………………………………..11
5. 更多的用户问题……………………………………………………………………………………………………..12
5.1. Strings bigger than defined String length……………………………………………………………………. 12
5.2. Decimal point doesn’t show in .csv output………………………………………………………………….. 13
5.3. Function call returning boolean fails in Oracle……………………………………………………………. 14
5.4. variables/arguments 的区别…………………………………………………….15
5.5. How to use database connections from repository……………………………………………………….. 15
5.6. 关于插入布尔类型的数据到MYSQL……………………………………………………………. 15
5.7. Calculator ignores result type on division…………………………………………………………………… 16
5.8. HTTP Client Step questions……………………………………………………………………………………… 17
5.8.1. The HTTP client step doesn’t do anything…………………………………………………………….17
5.8.2. The HTTP client step and SOAP………………………………………………………………………… 17
5.9. Javascript 的问题…………………………………………………………………………………………………. 18
5.9.1. How to check for the existence of fields in rows……………………………………………………18
5.9.2. How to add a new field in a row…………………………………………………………………………. 18
5.9.3. How to replace a field in a row…………………………………………………………………………… 19
5.9.4. How to create a new row…………………………………………………………………………………….20
5.9.5. How to use something as NVL in javascript?………………………………………………………..21
5.9.6. Example of how to split fields……………………………………………………………………………. 22
5.10. Shell job entry questions………………………………………………………………………………………….23
5.10.1. How to check for the return code of a shell script/batch file…………………………………. 23
5.11. 数据库存储过程调用的问题…………………………………………………………………………….23
5.11.1. The Call DB Procedure step doesn’t do anything………………………………………………… 23
6. Twilight user-development questions…………………………………………………………………………………24
6.1. Things that were once proposed but were rejected………………………………………………………..24
6.1.1. Implement connection type as a variable parameter ………………………………………………24
6.1.2. Implement “on the fly DDL” creation of tables, … ………………………………………………..24
6.1.3. Implement a step that shows a dialog and asks parameters…………………………………….. 25
6.1.4. Implement serialization of transformations using reflection…………………………………… 25
6.1.5. Implement retry on connection issues…………………………………………………………………..26
6.1.6. Implement GUI components in a transformation or job…………………………………………. 26
6.1.7. Hardcoding Locale…………………………………………………………………………………………….26
7. 开发过程中的问题…………………………………………………………………………………………………… 27
7.1. Development guidelines…………………………………………………………………………………………… 27
7.1.1. Priority on development……………………………………………………………………………………..27
7.1.2. Division of functionality in steps and job entries………………………………………………….. 27
7.1.3. Rows on a single hop have to be of the same structure………………………………………….. 27
7.1.4. Null 和 “”在PDI里面是一样的 ………………………………………………………………………….27
7.1.5. On converting data to fit the corresponding Metadata…………………………………………….28
7.1.6. On logging in steps in Pentaho Data Integration…………………………………………………… 29
7.1.7. On using XML in Pentaho Data Integration…………………………………………………………. 29
7.1.8. On dropdown boxes and storing values ………………………………………………………………. 29
7.1.9. On using I18N in PDI……………………………………………………………………………………….. 30
7.1.10. On using Locale’s in PDI…………………………………………………………………………………. 30
7.1.11. On reformatting source code……………………………………………………………………………..30
7.1.12. On using non-temporary storage………………………………………………………………………..31
7.2. On using Subversion…………………………………………………………………………………………………31
7.3. How do you start developing your own plug-in step……………………………………………………..32
7.4. Can you change the XML input step to process my file?……………………………………………….32
7.5. On Serializable and Binary………………………………………………………………………………………..33
7.6. Success factors of PDI……………………………………………………………………………………………… 34
7.6.1. Modular design………………………………………………………………………………………………… 34

以上都是Pentaho Data Integration version 2.5.0这个版本之前出现的问题，当前的版本可能有些修复了，列出来仅供平常开发参考，问题的答案请下载PDF文档：PDI_2_5_FAQ.pdf  大家有什么疑问可以回复我.