Data search functions

As you develop your HCL Integration Platform maps to search through data, you should consider the input format and the requirements for the output. Based upon those considerations, you can make your decision on which search function to use to for optimum performance results.

The following table lists search usage scenarios with the recommended function that should give you the best performance results.

Usage
Search Function Recommendation
Single output data item is the expected result and the input data cannot be sorted.
LOOKUP()

Multiple output data items are expected result.
EXTRACT()

The set of items to be searched is or can be sorted.
SEARCHUP() or SEARCHDOWN()

Same data type is being referenced (Positional Indexing).

In cases where CHOOSE() consistently references the same type, execution performance can exceed SEARCHUP() and SEARCHDOWN().

CHOOSE()