Class Lookup


  • @Generated(value="OracleSDKGenerator",
               comments="API Version: 20200430")
    public final class Lookup
    extends Operator
    The information about the lookup operator.

    The lookup operator has two input links, a primary input, and a lookup source input. It has an output link, fields of the lookup input are appended to the primary input and projected as the output fields.
    Note: Objects should always be created or deserialized using the Lookup.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the Lookup.Builder, which maintain a set of all explicitly set fields called Lookup.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

    • Method Detail

      • builder

        public static Lookup.Builder builder()
        Create a new builder.
      • getLookupCondition

        public Expression getLookupCondition()
      • getIsSkipNoMatch

        public Boolean getIsSkipNoMatch()
        For the rows for which lookup condition does not satisfy, if set to true - do not return those rows of primary Input source and if set to false - create a row with primary input fields values and lookup field values as NULL.
        Returns:
        the value
      • getMultiMatchStrategy

        public Lookup.MultiMatchStrategy getMultiMatchStrategy()
        if there are multiple records found in the lookup input what action should be performed.

        The default value for this field is RETURN_ANY.

        Returns:
        the value
      • getNullFillValues

        public Map<String,​Object> getNullFillValues()
        this map is used for replacing NULL values in the record.

        Key is the column name and value is the NULL replacement.

        Returns:
        the value
      • toString

        public String toString​(boolean includeByteArrayContents)
        Return a string representation of the object.
        Overrides:
        toString in class Operator
        Parameters:
        includeByteArrayContents - true to include the full contents of byte arrays
        Returns:
        string representation