public static final class LookupComponent.LookupType
extends java.lang.Enum
ATTENTIION: 1, To support OWB lookup migration, the concept Multiple Match Rows and No Match Rows introduced 2, To back support ODI 12.1.2, the LookupType property was reused as new meaning3, The migration combination as following OWB_MULTIPLE_MATCH_ROWS OWB_NO_MATCH_ROWS ODI12.1.2_LOOKUP_TYPE ODI12.1.3_MULTIPLE_MATCH_ROWS ODI12.1.3_NO_MATCH_ROWS ODI12.1.3_SQL_IMPL ALL_ROWS DEFAULT_VALUES LEFT_OUTER ALL_ROWS(LEFT_OUTER) DEFAULT_VALUES LEFT_OUTER_JOIN ALL_ROWS NO_ROW N/A ALL_ROWS(LEFT_OUTER) NO_ROW INNER_JOIN ERROR DEFAULT_VALUES EXPRESSION_IN_SELECT ERROR(ERROR_WHEN_MULTIPLE_ROW) DEFAULT_VALUES EXPRESSION_IN_SELECT NTH_SINGLE_ROW DEFAULT_VALUES N/A NTH_SINGLE_ROW DEFAULT_VALUES LEFT_OUTER_JOIN ANY_SINGLE_ROW DEFAULT_VALUES N/A ANY_SINGLE_ROW DEFAULT_VALUES EXPRESSION_IN_SELECT FIRST_SINGLE_ROW DEFAULT_VALUES N/A FIRST_SINGLE_ROW DEFAULT_VALUES EXPRESSION_IN_SELECT LAST_SINGLE_ROW DEFAULT_VALUES N/A LAST_SINGLE_ROW DEFAULT_VALUES EXPRESSION_IN_SELECT The tricky part one: when Multiple Match Rows populated with ALL_ROWS(actual value is LEFT_OUTER to back support ODI12.1.2) + No Match Rows populated with DEFAULT_VALUES meaning the implementation using LEFT_OUTER_JOIN which same as ODI12.1.2's behavior The tricky part two: when Multiple Match Rows populated with ALL_ROWS(actual value is LEFT_OUTER to back support ODI12.1.2) + No Match Rows populated with NO_ROW meaning the implementation using INNER_JOIN which is new behavior introduced by ODI12.1.3 to support OWB(ALL_ROWS+NO_ROW) The tricky part three: when Multiple Match Rows populated with ERROR(actual value is EXPRESSION_IN_SELECT to back support ODI12.1.2) + No Match Rows populated with DEFAULT_VALUES meaning the implementation using EXPRESSION_IN_SELECT which is same as ODI12.1.2's behavior.
Modifier and Type | Field and Description |
---|---|
static LookupComponent.LookupType |
ALL_ROWS |
static LookupComponent.LookupType |
ANY_ROW |
static LookupComponent.LookupType |
ERROR_WHEN_MULTIPLE_ROW |
static LookupComponent.LookupType |
EXPRESSION_IN_SELECT
Deprecated.
|
static LookupComponent.LookupType |
FIRST_ROW |
static LookupComponent.LookupType |
LAST_ROW |
static LookupComponent.LookupType |
LEFT_OUTER
Deprecated.
|
static LookupComponent.LookupType |
NTH_ROW |
Modifier and Type | Method and Description |
---|---|
static LookupComponent.LookupType |
valueOf(java.lang.String name) |
static LookupComponent.LookupType[] |
values() |
@Deprecated public static final LookupComponent.LookupType LEFT_OUTER
@Deprecated public static final LookupComponent.LookupType EXPRESSION_IN_SELECT
public static final LookupComponent.LookupType ALL_ROWS
public static final LookupComponent.LookupType ERROR_WHEN_MULTIPLE_ROW
public static final LookupComponent.LookupType ANY_ROW
public static final LookupComponent.LookupType FIRST_ROW
public static final LookupComponent.LookupType LAST_ROW
public static final LookupComponent.LookupType NTH_ROW
public static LookupComponent.LookupType[] values()
public static LookupComponent.LookupType valueOf(java.lang.String name)