Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: XML Join step for multiple target inputs !!

  1. #1
    Join Date
    Mar 2013
    Posts
    66

    Default XML Join step for multiple target inputs !!

    Hi

    Thanks in advance for your support, and here is my problem,

    I have two tables in DB, Master & Child, both are related with field MSISDN,

    For each row in Master table, I create an XML and would like to add related child to it from Child table.

    Example

    <SUBSCRIBER>
    <MSISDN></MSISDN> <!-- Master Table-->
    <IMSI></IMSI> <!-- Master Table-->
    <PUK1></PUK1> <!-- Master Table-->
    <LIST>
    <CHILD_INFO>
    <FAFNumber></FAFNumber> <!-- Child Table-->
    <PROFILE></PROFILE> <!-- Child Table-->
    </CHILD_INFO>
    <CHILD_INFO>
    <FAFNumber></FAFNumber> <!-- Child Table-->
    <PROFILE></PROFILE> <!-- Child Table-->
    </CHILD_INFO>
    </LIST>
    </SUBSCRIBER

    How can I do this job using XML join step ? I could not achieve this because XML join step expects one row from target step.

    but i got the solution using group by, string replace and other steps.

    Please advice how can it be achieved using XML join step. Give me a tip.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You can use a job for this.
    Let the first transformation copy the rows from the master table to the result stream.
    Execute the second transformation for every input row, so XML Join requirements are met.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Mar 2013
    Posts
    66

    Default

    Quote Originally Posted by marabu View Post
    You can use a job for this.
    Let the first transformation copy the rows from the master table to the result stream.
    Execute the second transformation for every input row, so XML Join requirements are met.
    Thank you so much. Just one more clarification, Copy rows to result says that, a step to transfer rows of data (in memory) to the next transformation (job entry) in a job. If there is millions of data, will this impact like out of heap/memory. Please advise.
    Last edited by harikumar_23; 12-30-2013 at 08:40 AM.

Tags for this Thread

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.