Pentaho Transformation : Simple Transformation Oracle - MySQL

1. Click File > New > Transformation

 

2. Ini Transformation form

3. Save Transformation as "SimpleTransformation"

4. Share Oracle & MySQL Connection first before use for next step

 5. Go to Design tab > expand Input > Drag Table Input

 6. Write Step Name : Table VKOD_JABATAN
              Connection : Select Oracle
              SQL : Input SQL Statment

7. Expand Output > Drag Insert /Update

 8. Drag hope from Table VKOD_JABATAN to Insert /Update

 

9. Double Click Insert / Update
   Write Step Name    : Insert / Update

              Connection   : Select MySQL
              Target Table : STARSCodeDepartment

10. Follow screen shoot for The Key(s) to look up value(s) :
                                        Update Field Mapping :

 11 . Run process