Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Lookup issue

  1. #1

    Default Lookup issue

    Hi,

    I have a requirement like: lookup the matching values by DB lookup and pass the all values to output.

    mapping like :
    DB INPUT-->select values-->DB LOOKUP--->select values---->DB OUTPUT.

    but in results i am getting first matching value(1 to 1 relationship) only.
    I have a question like penatho can support the 1-to-many relationships for lookup...?



    Regards,
    pradeep
    Last edited by pradeep06; 11-30-2008 at 11:53 PM.

  2. #2

    Default Any idea......?

    Hi,

    Could any one please tell me whethere Pentaho lookup will work on ROW-by-ROW basis only or it will support one-to-many Relationships also.


    Regards,
    Pradeep

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

    Default

    You can do 1-to-many as well if you use steps like "Database Join" or "Merge Join".

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.