Pentaho Data Integration 4 Cookbook by Unknown

Author:Unknown
Language: eng
Format: epub
Publisher: Packt Publishing

There's more...

The following sections provide you with some alternatives to the use of the Stream Lookup step.

Looking for alternatives when the Stream Lookup step doesn't meet your needs

The Stream Lookup step compares the fields with an equal operator. There are a couple of situations where this may not be what you need.

If you are not sure about the similarity of the values between the fields that you are comparing, a comparison by equal may fail. In that case, you could use the Fuzzy match step, which allows you to search for similar values.

If you need to compare using other operators, for example <=, then you should also look for an alternative step. One possible approach would be to use the Join Rows (Cartesian product) to retrieve all the data and filter the rows from that step with a Filter rows or a Java Filter step afterward.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.