View Full Version : Merge join help in Pentaho Kettle 4.3 version

03-30-2015, 04:11 AM
Hi All,

I am struggling to use Merge join when connecting with two input sources

Source 1 from SQL Server database and Source 2 from DB2 database. Join condition is on a field called person_number

SQL Server has integer data and DB2 has alphanumeric data

When I have used Merge join to join both table inputs nothing is coming out of that step to target and I could see data only when DB2 is restricted to extract integer instead of alphanumeric

I tried Cast/Conversion in Table input of DB2 and sql server to convert the person_number data type but still it's of no use.

Please help me how to use merge join effectively

Best Regards

04-19-2015, 07:40 PM
Did you manage to solve your problem?!