Class Lookup

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.

Inheritance

object

Operator

Lookup

Inherited Members

Operator.Key

Operator.ModelVersion

Operator.ParentRef

Operator.Name

Operator.Description

Operator.ObjectVersion

Operator.InputPorts

Operator.OutputPorts

Operator.ObjectStatus

Operator.Identifier

Operator.Parameters

Operator.OpConfigValues

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DataintegrationService.Models

Assembly: OCI.DotNetSDK.Dataintegration.dll

Syntax

public class Lookup : Operator

Properties

IsSkipNoMatch

Declaration

[JsonProperty(PropertyName = "isSkipNoMatch")]
public bool? IsSkipNoMatch { get; set; }

Property Value

Type	Description
bool?	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.

LookupCondition

Declaration

[JsonProperty(PropertyName = "lookupCondition")]
public Expression LookupCondition { get; set; }

Property Value

Type	Description
Expression

MultiMatchStrategy

Declaration

[JsonProperty(PropertyName = "multiMatchStrategy")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Lookup.MultiMatchStrategyEnum? MultiMatchStrategy { get; set; }

Property Value

Type	Description
Lookup.MultiMatchStrategyEnum?	if there are multiple records found in the lookup input what action should be performed. The default value for this field is RETURN_ANY.

NullFillValues

Declaration

[JsonProperty(PropertyName = "nullFillValues")]
public Dictionary<string, object> NullFillValues { get; set; }

Property Value

Type	Description
Dictionary<string, object>	this map is used for replacing NULL values in the record. Key is the column name and value is the NULL replacement.