Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Database lookup

  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Default Database lookup

    What is the best way to make database lookup with custom SQL?
    The problem I came up with is following. Database lookup step correctly return errors - in case of zero or multiple rows return, but it dosn't allow to write sql query for those result(only one table). Database join do exectly what I need, but it can't validate row count and I have to write separete step and seperate sql call to do those validation. Is there a better way to solve this problem?

  2. #2
    Join Date
    Jul 2008
    Posts
    3

    Default

    Have the same question. Any suggestions?
    Thanks

  3. #3
    Join Date
    Mar 2006
    Posts
    170

    Default

    Hey All,

    Why not use a Table Input Step that gets the keys & return values you were using in the DB lkup step. Now use a Stream Lkup step to join those values to your main stream ... I believe that would work for you.

    Thoughts?

    Thx

    Kent

  4. #4

    Default

    I have done this (table input + strean lookup) and it worked correctly. But I also think that the table lookup should work.

    Osmar Mateus

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.