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.
Inherited Members
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. |