Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Merging 3 or more datasources

  1. #1
    Join Date
    Mar 2012
    Posts
    18

    Default Merging 3 or more datasources

    Hi All,

    I want to merge 3 datasources into single table.It means
    Table1 :CustomerName

    Table2 :CustomerId

    Table 3 ccupation

    Now,finaltable must consists of CustomerName,CustomerID,Occupation.

    Here,I can do FULL-OUTER Join using MERGE component.But,it is limited to two datasourcs only.How can I do this if i have this requirement.Please suggest me.Please.Please.Please:-):-):-)

    Thanks
    Krishna Murtyu

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    If it's in the same database, use SQL.
    If not in the same database either use 2 Merge Join steps or the experimental Multi-Join step. Sort on the database.

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.