Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: When to use Lookup vs Database Join

  1. #1

    Default When to use Lookup vs Database Join

    How do we decide when it is better to use a lookup or a database join?

    Could you please provide me an example of the usage of a lookup? I was searching for it on the examples base, but could not find anything lookup related.

    Best regards,

    Reinaldo A Vasconcellos
    Brazil.

  2. #2

    Default

    Using database join will run the join query for every row. If you use lookup, the join table is stored in cache and kettle does the join instead.

    You may see better performance with stream lookup if the entire table can be cached.

    Hope that helps

  3. #3

    Thumbs up

    Thks for the replay acimi.

    I will try to see if I can use the stream lookup on my transformation and see how the performance goes.

    Best Regards,

    Reinaldo A Vasconcellos

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.