Pentaho Database Lookup

[@efrainplaza]

Great Demo! It helped me fix a problem I had while trying to use Lookups with Sorts, I replaced them with Database Lookups and now the transformation runs way faster and does not crash with memory issues, thanks!

[@sabeensadaf4926]

rows which don't have matching order number with orderfact will be discarded or kept ?

[@pratiksawalkar1531]

link for the alternative solution to perform the same in a faster way?

[@KPTechShares]

Stream look-up step, it is available in the video list

[@madhavilatha8409]

Sir,e Please explain what is the difference between database lookup and stream lookup

[@KPTechShares]

Stream Look up is faster than DB look up as Stream look up step keeps look up data in cache for comparision where DB look up step, every time hits the table for scanning. For smaller amount of data DB look up is fine but if you are having high volume of data to compare then go for Stream look up