Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Difference between stream value lookup and database lookup step

  1. #1
    Join Date
    Aug 2008
    Posts
    187

    Default Difference between stream value lookup and database lookup step

    Hi,I'm new to kettle. I use kettle 3.0.4.
    What's the difference between stream value lookup and database lookup ??
    I see (if I am not mistaken) that we can achieve the same thing by using both (for example when we want to lookup values on one table and retrieve some other columns)
    And in which case we better use stream value lookup than the other one and vice versa...
    Thanks in advance...

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

    Default

    If you're new use 3.1GA

    Stream lookup sucks the data in memory and then will start doing all of the lookups, data can come from anywhere (also from file e.g.).

    Database lookup looks up data from a database, and only touches the data you lookup.


    stream lookup for fast lookups on small sizes of data... database lookup for databases.

    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 - 2017 Pentaho Corporation. All Rights Reserved.