Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Database join question

  1. #1

    Default Database join question

    I need to perform a database join based on input keys, as part of a transform. Is there a way to tell the JOIN step to skip the join if the input key is not specified. If not, what is an efficient way to do this ?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    No way in "database join"... filter out the rows beforehand and add the fields in the filtered rows which would normally be returned by database join: all rows flowing over 1 hop have to be of the same structure.

    Regards,
    Sven

  3. #3

    Default

    Thanks - thats what I ended up doing. But now I am faced with the problem of having both streams go to the same step (for validation). I thought that I could do this with a dummy step - but that does not appear to be working.

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Dummy step just copies rows from input to output.

    What do you want it to do?

    Regards,
    Sven

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.