Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Merge join help in Pentaho Kettle 4.3 version

  1. #1
    Join Date
    Mar 2015

    Question Merge join help in Pentaho Kettle 4.3 version

    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

  2. #2
    Join Date
    Mar 2015


    Did you manage to solve your problem?!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.