Lookup collected rows
First, the step reads all records coming in through the lookup gate and indexes them in memory. It uses the fields supplied in the key fields configuration on the lookup side to index each row. If multiple rows yield the same index values, only the latest row is indexed.
When all rows are indexed, the step reads records coming in through the in gate, and performs one lookup per incoming row. It uses the key fields configured on the in side of the key fields configuration.
The row found by looking up the keys is made available as results.lookup.
- the lookup fields are used to index rows coming in from the lookup gate
- the in fields are used to look up any corresponding row for each row coming in from the in gate
The row found by looking up the current in fields in the index.
If no row is indexed by corresponding values in lookup fields, the value is