Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: how to use the transformation result for the next one ?

  1. #1
    Join Date
    Jan 2009
    Posts
    11

    Default how to use the transformation result for the next one ?

    In "job entry details" for the transformation, we have the choices "copy prev.results to args" and "execute once for each input".

    but how this system works ?

    I want to make a transformation with a data from prior but I 've some difficults to exploit it ...

    I think It's because I'm not an expert with ETL ...

    Thanks for your help
    Attached Images Attached Images

  2. #2
    Join Date
    Feb 2009
    Posts
    321

    Default

    execute for every row, executed for each record (in a previous transformation or job) that job,... is like a cursor.

  3. #3
    Join Date
    Jan 2009
    Posts
    11

    Default

    Quote Originally Posted by hernanthiebaut View Post
    execute for every row, executed for each record (in a previous transformation or job) that job,... is like a cursor.
    Ok, I can transfer a result row by row to next transformation

    But, when I want to transfer to the next one I have an infinite loop !

    my job :

    transfo1 -> (result1) -> transfo2 -> (same result) -> transfo3

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

    Default

    What if you do it in a sub-job?

  5. #5
    Join Date
    Jan 2009
    Posts
    11

    Default

    at this time it's just a model (because I 've problem with penteho)...

    my job TEST1TON with transformation TEST1TON01 (for list of ent from file2 with 2 fields ent det) TEST1TON02 and TEST1TON03 to generate output file names file3${ent}
    Attached Images Attached Images

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.