oracle.owb.mapping
Class PropDefOperatorLogical

java.lang.Object
  |
  +--oracle.owb.mapping.PropDefCommon
        |
        +--oracle.owb.mapping.PropDefOperatorLogical

public class PropDefOperatorLogical

extends PropDefCommon

PropDefOperatorLogical defines all operator logical properties.

Field Summary

static java.lang.String	ADVANCED_QUEUE$SQL$BOUND_NAME_STRING Logical property on advanced_queue operator.
static java.lang.String	AGGREGATOR$SQL$GROUP_BY_CLAUSE_STRING Logical property on aggregator operator.
static java.lang.String	AGGREGATOR$SQL$HAVING_CLAUSE_STRING Logical property on aggregator operator.
static java.lang.String	CUBE$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING Logical property on cube operator.
static java.lang.String	CUBE$SQL$BOUND_NAME_STRING Logical property on cube operator.
static java.lang.String	CUBE$SQL$KEYS_READONLY_ML1LIST Logical property on cube operator.
static java.lang.String	CUBE$SQL$LOADING_TYPE_STRING Logical property on cube operator.
static java.lang.String	CUBE$SQL$MATCH_BY_CONSTRAINT_STRING Logical property on cube operator.
static java.lang.String	CUBE$SQL$PRIMARY_SOURCE_STRING Logical property on cube operator.
static java.lang.String	CUBE$SQL$TARGET_FILTER_FOR_DELETE_STRING Logical property on cube operator.
static java.lang.String	CUBE$SQL$TARGET_FILTER_FOR_UPDATE_STRING Logical property on cube operator.
static java.lang.String	DIMENSION$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING Logical property on dimension operator.
static java.lang.String	DIMENSION$SQL$BOUND_NAME_STRING Logical property on dimension operator.
static java.lang.String	DIMENSION$SQL$KEYS_READONLY_ML1LIST Logical property on dimension operator.
static java.lang.String	DIMENSION$SQL$LOADING_TYPE_STRING Logical property on dimension operator.
static java.lang.String	DIMENSION$SQL$MATCH_BY_CONSTRAINT_STRING Logical property on dimension operator.
static java.lang.String	DIMENSION$SQL$PRIMARY_SOURCE_STRING Logical property on dimension operator.
static java.lang.String	DIMENSION$SQL$TARGET_FILTER_FOR_DELETE_STRING Logical property on dimension operator.
static java.lang.String	DIMENSION$SQL$TARGET_FILTER_FOR_UPDATE_STRING Logical property on dimension operator.
static java.lang.String	EXTERNAL_TABLE$SQL$BOUND_NAME_STRING Logical property on external_table operator.
static java.lang.String	EXTERNAL_TABLE$SQL$PRIMARY_SOURCE_STRING Logical property on external_table operator.
static java.lang.String	FILTER$SQL$FILTER_CONDITION_STRING Logical property on filter operator.
static java.lang.String	FLAT_FILE$SQLLOADER$CONCATENATE_RECORDS_INTEGER Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$CONTINUATION_CHARACTER_ON_NEXT_LINE_BOOLEAN Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$CONTINUATION_CHARACTER_STRING Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$FIELD_ENCLOSURE_CHARACTERS_STRING Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$FIELD_NAMES_IN_THE_FIRST_ROW_BOOLEAN Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$FIELD_TERMINATION_CHARACTER_STRING Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$FILE_FORMAT_STRING Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$LOADING_TYPE_STRING Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$NLS_CHARACTERSET_STRING Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$RECORD_DELIMITER_STRING Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$RECORD_SIZE_INTEGER Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$RECORD_TYPE_LENGTH_INTEGER Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$RECORD_TYPE_POSITION_INTEGER Logical property on flat_file operator.
static java.lang.String	FLAT_FILE$SQLLOADER$SAMPLED_FILE_NAME_STRING Logical property on flat_file operator.
static java.lang.String	JOINER$SQL$JOIN_CONDITION_STRING Logical property on joiner operator.
static java.lang.String	KEY_LOOKUP$SQL$BOUND_NAME_STRING Logical property on key_lookup operator.
static java.lang.String	KEY_LOOKUP$SQL$KEYS_READONLY_ML1LIST Logical property on key_lookup operator.
static java.lang.String	KEY_LOOKUP$SQL$LOOKUP_CONDITION_STRING Logical property on key_lookup operator.
static java.lang.String	MATCHMERGE$SQL$MATCH_KEYS_STRING Logical property on matchmerge operator.
static java.lang.String	MATCHMERGE$SQL$MATCH_RULES_ML2LIST Logical property on matchmerge operator.
static java.lang.String	MATCHMERGE$SQL$MERGE_RULES_ML3LIST Logical property on matchmerge operator.
static java.lang.String	MATCHMERGE$SQL$MERGED_PREFIX_STRING Logical property on matchmerge operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING Logical property on materialized_view operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$BOUND_NAME_STRING Logical property on materialized_view operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$KEYS_READONLY_ML1LIST Logical property on materialized_view operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$LOADING_TYPE_STRING Logical property on materialized_view operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$MATCH_BY_CONSTRAINT_STRING Logical property on materialized_view operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$PRIMARY_SOURCE_STRING Logical property on materialized_view operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$TARGET_FILTER_FOR_DELETE_STRING Logical property on materialized_view operator.
static java.lang.String	MATERIALIZED_VIEW$SQL$TARGET_FILTER_FOR_UPDATE_STRING Logical property on materialized_view operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_1_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_2_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_3_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_4_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$DUAL_ADDRESS_ASSIGNMENT_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$GENERATE_CASS_REPORT_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$LIST_NAME_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$PARSING_TYPE_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$PRIMARY_COUNTRY_STRING Logical property on name_and_address operator.
static java.lang.String	NAME_AND_ADDRESS$PLSQL$PROCESSOR_NAME_STRING Logical property on name_and_address operator.
static java.lang.String	PIVOT$SQL$PIVOT_GROUP_SIZE_INTEGER Logical property on pivot operator.
static java.lang.String	POSTMAPPING_PROCESS$SQL$FUNCTION_CALL_STRING Logical property on postmapping_process operator.
static java.lang.String	POSTMAPPING_PROCESS$SQL$FUNCTION_NAME_STRING Logical property on postmapping_process operator.
static java.lang.String	POSTMAPPING_PROCESS$SQL$POSTMAPPING_PROCESS_RUN_CONDITION_STRING Logical property on postmapping_process operator.
static java.lang.String	POSTMAPPING_PROCESS$SQL$ROWBASED_ONLY_BOOLEAN Logical property on postmapping_process operator.
static java.lang.String	PREMAPPING_PROCESS$SQL$FUNCTION_CALL_STRING Logical property on premapping_process operator.
static java.lang.String	PREMAPPING_PROCESS$SQL$FUNCTION_NAME_STRING Logical property on premapping_process operator.
static java.lang.String	PREMAPPING_PROCESS$SQL$MAPPING_RUN_CONDITION_STRING Logical property on premapping_process operator.
static java.lang.String	PREMAPPING_PROCESS$SQL$ROWBASED_ONLY_BOOLEAN Logical property on premapping_process operator.
static java.lang.String	SEQUENCE$SQL$BOUND_NAME_STRING Logical property on sequence operator.
static java.lang.String	SET_OPERATION$SQL$SET_OPERATION_STRING Logical property on set_operation operator.
static java.lang.String	SORTER$SQL$ORDER_BY_CLAUSE_STRING Logical property on sorter operator.
static java.lang.String	TABLE_FUNCTION$SQL$TABLE_FUNCTION_NAME_STRING Logical property on table_function operator.
static java.lang.String	TABLE$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING Logical property on table operator.
static java.lang.String	TABLE$SQL$BOUND_NAME_STRING Logical property on table operator.
static java.lang.String	TABLE$SQL$KEYS_READONLY_ML1LIST Logical property on table operator.
static java.lang.String	TABLE$SQL$LOADING_TYPE_STRING Logical property on table operator.
static java.lang.String	TABLE$SQL$MATCH_BY_CONSTRAINT_STRING Logical property on table operator.
static java.lang.String	TABLE$SQL$PRIMARY_SOURCE_STRING Logical property on table operator.
static java.lang.String	TABLE$SQL$TARGET_FILTER_FOR_DELETE_STRING Logical property on table operator.
static java.lang.String	TABLE$SQL$TARGET_FILTER_FOR_UPDATE_STRING Logical property on table operator.
static java.lang.String	TRANSFORMATION$SQL$FUNCTION_NAME_STRING Logical property on transformation operator.
static java.lang.String	TRANSFORMATION$SQL$ROWBASED_ONLY_BOOLEAN Logical property on transformation operator.
static java.lang.String	VIEW$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING Logical property on view operator.
static java.lang.String	VIEW$SQL$BOUND_NAME_STRING Logical property on view operator.
static java.lang.String	VIEW$SQL$KEYS_READONLY_ML1LIST Logical property on view operator.
static java.lang.String	VIEW$SQL$LOADING_TYPE_STRING Logical property on view operator.
static java.lang.String	VIEW$SQL$MATCH_BY_CONSTRAINT_STRING Logical property on view operator.
static java.lang.String	VIEW$SQL$PRIMARY_SOURCE_STRING Logical property on view operator.
static java.lang.String	VIEW$SQL$TARGET_FILTER_FOR_DELETE_STRING Logical property on view operator.
static java.lang.String	VIEW$SQL$TARGET_FILTER_FOR_UPDATE_STRING Logical property on view operator.

Fields inherited from class oracle.owb.mapping.PropDefCommon

DEFAULT_BOOLEAN_DOMAIN, DEFAULT_FLOAT_DOMAIN, DEFAULT_INTEGER_DOMAIN, DEFAULT_PROPERTYOWNER_DOMAIN, DEFAULT_STRING_DOMAIN

Constructor Summary

PropDefOperatorLogical()

Method Summary

protected static boolean	containsKey(java.lang.String type, java.lang.String key) containsKey is a boolean checkup to see if this set of property definitions includes the definition for the key.
protected static oracle.owb.mapping.PropSheetImpl	getPropSheet(java.lang.String type) getPropSheet Retrieve the property sheet of a property type.

Methods inherited from class oracle.owb.mapping.PropDefCommon

translate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ADVANCED_QUEUE$SQL$BOUND_NAME_STRING

public static final java.lang.String ADVANCED_QUEUE$SQL$BOUND_NAME_STRING

Logical property on advanced_queue operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

FILTER$SQL$FILTER_CONDITION_STRING

public static final java.lang.String FILTER$SQL$FILTER_CONDITION_STRING

Logical property on filter operator. Key name: FILTER_CONDITION.

Description: The boolean filtering condition that identifies what data is to be processed. Any row with a false condition will be ignored.

See Also:

Constant Field Values

PIVOT$SQL$PIVOT_GROUP_SIZE_INTEGER

public static final java.lang.String PIVOT$SQL$PIVOT_GROUP_SIZE_INTEGER

Logical property on pivot operator. Key name: PIVOT_GROUP_SIZE.

Description: A number specifying the pivot group size for the pivot operation. Pivot group size determines the number of output rows that are produced from each input row.

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$PARSING_TYPE_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$PARSING_TYPE_STRING

Logical property on name_and_address operator. Key name: PARSING_TYPE.

Description: Select a name-address parsing type to be performed on the input data

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$PRIMARY_COUNTRY_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$PRIMARY_COUNTRY_STRING

Logical property on name_and_address operator. Key name: PRIMARY_COUNTRY.

Description: Select the primary parsing country which best represents the input data. Input addresses having the same country as the primary parsing country will only need to be parsed once. Input addresses having a different country than the primary parsing country may be reparsed by a different parser. For performance reasons, it is best to minimize the percentage of 2-pass parses by selecting the optimal parser.

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$DUAL_ADDRESS_ASSIGNMENT_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$DUAL_ADDRESS_ASSIGNMENT_STRING

Logical property on name_and_address operator. Key name: DUAL_ADDRESS_ASSIGNMENT.

Description: A dual address refers to two address lines for the same destination. For example, a record contains both a street address and a P.O. Box; this is common with business data. Select which of the two address lines should be assigned in these cases.

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$GENERATE_CASS_REPORT_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$GENERATE_CASS_REPORT_STRING

Logical property on name_and_address operator. Key name: GENERATE_CASS_REPORT.

Description: Select "Yes" to generate CASS (Coding Accuracy Support System) report. CASS report is a text file specified by the United States Postal Service. The report is written to the [nas/bin/admin/reports] folder under the home folder of the name/address server.

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$PROCESSOR_NAME_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$PROCESSOR_NAME_STRING

Logical property on name_and_address operator. Key name: PROCESSOR_NAME.

Description: The processor name is the name of the organization submitting the CASS report.

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$LIST_NAME_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$LIST_NAME_STRING

Logical property on name_and_address operator. Key name: LIST_NAME.

Description: The list name is optional and provides a reference for tracking multiple CASS reports.

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_1_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_1_STRING

Logical property on name_and_address operator. Key name: ADDRESS_LINE_1.

Description: Address line 1

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_2_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_2_STRING

Logical property on name_and_address operator. Key name: ADDRESS_LINE_2.

Description: Address line 2

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_3_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_3_STRING

Logical property on name_and_address operator. Key name: ADDRESS_LINE_3.

Description: Address line 3

See Also:

Constant Field Values

NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_4_STRING

public static final java.lang.String NAME_AND_ADDRESS$PLSQL$ADDRESS_LINE_4_STRING

Logical property on name_and_address operator. Key name: ADDRESS_LINE_4.

Description: Address line 4

See Also:

Constant Field Values

TABLE_FUNCTION$SQL$TABLE_FUNCTION_NAME_STRING

public static final java.lang.String TABLE_FUNCTION$SQL$TABLE_FUNCTION_NAME_STRING

Logical property on table_function operator. Key name: TABLE_FUNCTION_NAME.

Description: The name of the Table Function

See Also:

Constant Field Values

CUBE$SQL$BOUND_NAME_STRING

public static final java.lang.String CUBE$SQL$BOUND_NAME_STRING

Logical property on cube operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

CUBE$SQL$PRIMARY_SOURCE_STRING

public static final java.lang.String CUBE$SQL$PRIMARY_SOURCE_STRING

Logical property on cube operator. Key name: PRIMARY_SOURCE.

Description: A boolean value to indicate whether this is a primary source or not (only used in EDW).

See Also:

Constant Field Values

CUBE$SQL$LOADING_TYPE_STRING

public static final java.lang.String CUBE$SQL$LOADING_TYPE_STRING

Logical property on cube operator. Key name: LOADING_TYPE.

Description: The loading operation to be performed when this is a target.

See Also:

Constant Field Values

CUBE$SQL$TARGET_FILTER_FOR_UPDATE_STRING

public static final java.lang.String CUBE$SQL$TARGET_FILTER_FOR_UPDATE_STRING

Logical property on cube operator. Key name: TARGET_FILTER_FOR_UPDATE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.

See Also:

Constant Field Values

CUBE$SQL$TARGET_FILTER_FOR_DELETE_STRING

public static final java.lang.String CUBE$SQL$TARGET_FILTER_FOR_DELETE_STRING

Logical property on cube operator. Key name: TARGET_FILTER_FOR_DELETE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.

See Also:

Constant Field Values

CUBE$SQL$MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String CUBE$SQL$MATCH_BY_CONSTRAINT_STRING

Logical property on cube operator. Key name: MATCH_BY_CONSTRAINT.

Description: A property to indicate whether unique or primary key information on this target will override the matching criteria obtained from Match by constraint property on the attributes of this target.

See Also:

Constant Field Values

CUBE$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String CUBE$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

Logical property on cube operator. Key name: ADVANCED_MATCH_BY_CONSTRAINT.

Description: This property is used by public API and scripting to influence how columns are used for UPDATE or DELETE DMLs. If this property is set with the name of a primary or unique key, all the columns in the key will be used for matching during UPDATE or DELETE; and all the columns not in the key are used for loading. The property can also be assigned the value "All constraints" or "No constraints". If the DML type is INSERT, TRUNCATE/INSERT, or CHECK/INSERT, setting this property causes no effect.

See Also:

Constant Field Values

CUBE$SQL$KEYS_READONLY_ML1LIST

public static final java.lang.String CUBE$SQL$KEYS_READONLY_ML1LIST

Logical property on cube operator. Key name: KEYS_READONLY.

Description: None.

See Also:

Constant Field Values

DIMENSION$SQL$BOUND_NAME_STRING

public static final java.lang.String DIMENSION$SQL$BOUND_NAME_STRING

Logical property on dimension operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

DIMENSION$SQL$PRIMARY_SOURCE_STRING

public static final java.lang.String DIMENSION$SQL$PRIMARY_SOURCE_STRING

Logical property on dimension operator. Key name: PRIMARY_SOURCE.

Description: A boolean value to indicate whether this is a primary source or not (only used in EDW).

See Also:

Constant Field Values

DIMENSION$SQL$LOADING_TYPE_STRING

public static final java.lang.String DIMENSION$SQL$LOADING_TYPE_STRING

Logical property on dimension operator. Key name: LOADING_TYPE.

Description: The loading operation to be performed when this is a target.

See Also:

Constant Field Values

DIMENSION$SQL$TARGET_FILTER_FOR_UPDATE_STRING

public static final java.lang.String DIMENSION$SQL$TARGET_FILTER_FOR_UPDATE_STRING

Logical property on dimension operator. Key name: TARGET_FILTER_FOR_UPDATE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.

See Also:

Constant Field Values

DIMENSION$SQL$TARGET_FILTER_FOR_DELETE_STRING

public static final java.lang.String DIMENSION$SQL$TARGET_FILTER_FOR_DELETE_STRING

Logical property on dimension operator. Key name: TARGET_FILTER_FOR_DELETE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.

See Also:

Constant Field Values

DIMENSION$SQL$MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String DIMENSION$SQL$MATCH_BY_CONSTRAINT_STRING

Logical property on dimension operator. Key name: MATCH_BY_CONSTRAINT.

Description: A property to indicate whether unique or primary key information on this target will override the matching criteria obtained from Match by constraint property on the attributes of this target.

See Also:

Constant Field Values

DIMENSION$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String DIMENSION$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

Logical property on dimension operator. Key name: ADVANCED_MATCH_BY_CONSTRAINT.

Description: This property is used by public API and scripting to influence how columns are used for UPDATE or DELETE DMLs. If this property is set with the name of a primary or unique key, all the columns in the key will be used for matching during UPDATE or DELETE; and all the columns not in the key are used for loading. The property can also be assigned the value "All constraints" or "No constraints". If the DML type is INSERT, TRUNCATE/INSERT, or CHECK/INSERT, setting this property causes no effect.

See Also:

Constant Field Values

DIMENSION$SQL$KEYS_READONLY_ML1LIST

public static final java.lang.String DIMENSION$SQL$KEYS_READONLY_ML1LIST

Logical property on dimension operator. Key name: KEYS_READONLY.

Description: None.

See Also:

Constant Field Values

MATCHMERGE$SQL$MERGED_PREFIX_STRING

public static final java.lang.String MATCHMERGE$SQL$MERGED_PREFIX_STRING

Logical property on matchmerge operator. Key name: MERGED_PREFIX.

Description: Set the prefix used for the merged attributes in the cross-reference group.

See Also:

Constant Field Values

MATCHMERGE$SQL$MATCH_KEYS_STRING

public static final java.lang.String MATCHMERGE$SQL$MATCH_KEYS_STRING

Logical property on matchmerge operator. Key name: MATCH_KEYS.

Description: Ordered list of attributes that control the set of records to be matched at any at any particular time.

See Also:

Constant Field Values

MATCHMERGE$SQL$MATCH_RULES_ML2LIST

public static final java.lang.String MATCHMERGE$SQL$MATCH_RULES_ML2LIST

Logical property on matchmerge operator. Key name: MATCH_RULES.

Description: Folder for match rules.

See Also:

Constant Field Values

MATCHMERGE$SQL$MERGE_RULES_ML3LIST

public static final java.lang.String MATCHMERGE$SQL$MERGE_RULES_ML3LIST

Logical property on matchmerge operator. Key name: MERGE_RULES.

Description: Merge Rules

See Also:

Constant Field Values

AGGREGATOR$SQL$GROUP_BY_CLAUSE_STRING

public static final java.lang.String AGGREGATOR$SQL$GROUP_BY_CLAUSE_STRING

Logical property on aggregator operator. Key name: GROUP_BY_CLAUSE.

Description: The Group By clause for the aggregation

See Also:

Constant Field Values

AGGREGATOR$SQL$HAVING_CLAUSE_STRING

public static final java.lang.String AGGREGATOR$SQL$HAVING_CLAUSE_STRING

Logical property on aggregator operator. Key name: HAVING_CLAUSE.

Description: The Having clause for the aggregation

See Also:

Constant Field Values

SORTER$SQL$ORDER_BY_CLAUSE_STRING

public static final java.lang.String SORTER$SQL$ORDER_BY_CLAUSE_STRING

Logical property on sorter operator. Key name: ORDER_BY_CLAUSE.

Description: The Order By Clause

See Also:

Constant Field Values

PREMAPPING_PROCESS$SQL$FUNCTION_NAME_STRING

public static final java.lang.String PREMAPPING_PROCESS$SQL$FUNCTION_NAME_STRING

Logical property on premapping_process operator. Key name: FUNCTION_NAME.

Description: Name of the transformation to be called.

See Also:

Constant Field Values

PREMAPPING_PROCESS$SQL$FUNCTION_CALL_STRING

public static final java.lang.String PREMAPPING_PROCESS$SQL$FUNCTION_CALL_STRING

Logical property on premapping_process operator. Key name: FUNCTION_CALL.

Description: Expression template for procedure call

See Also:

Constant Field Values

PREMAPPING_PROCESS$SQL$ROWBASED_ONLY_BOOLEAN

public static final java.lang.String PREMAPPING_PROCESS$SQL$ROWBASED_ONLY_BOOLEAN

Logical property on premapping_process operator. Key name: ROWBASED_ONLY.

Description: Indicates if this transformation must be used only Row Based mode. Some transformations can be used in SQL mode as well as Row Based mode.

See Also:

Constant Field Values

PREMAPPING_PROCESS$SQL$MAPPING_RUN_CONDITION_STRING

public static final java.lang.String PREMAPPING_PROCESS$SQL$MAPPING_RUN_CONDITION_STRING

Logical property on premapping_process operator. Key name: MAPPING_RUN_CONDITION.

Description: Indicates under what condition of the pre-mapping process the mapping will be run.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$LOADING_TYPE_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$LOADING_TYPE_STRING

Logical property on flat_file operator. Key name: LOADING_TYPE.

Description: The loading operation to be performed

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$SAMPLED_FILE_NAME_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$SAMPLED_FILE_NAME_STRING

Logical property on flat_file operator. Key name: SAMPLED_FILE_NAME.

Description: The name of the file that was sampled to get the metadata for this file.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$NLS_CHARACTERSET_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$NLS_CHARACTERSET_STRING

Logical property on flat_file operator. Key name: NLS_CHARACTERSET.

Description: NLS Characterset

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$FILE_FORMAT_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$FILE_FORMAT_STRING

Logical property on flat_file operator. Key name: FILE_FORMAT.

Description: File Format (Fixed or Delimited).

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$RECORD_DELIMITER_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$RECORD_DELIMITER_STRING

Logical property on flat_file operator. Key name: RECORD_DELIMITER.

Description: Character that indicates the end of the record.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$CONTINUATION_CHARACTER_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$CONTINUATION_CHARACTER_STRING

Logical property on flat_file operator. Key name: CONTINUATION_CHARACTER.

Description: Character that indicates the record is continued on the next line.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$CONTINUATION_CHARACTER_ON_NEXT_LINE_BOOLEAN

public static final java.lang.String FLAT_FILE$SQLLOADER$CONTINUATION_CHARACTER_ON_NEXT_LINE_BOOLEAN

Logical property on flat_file operator. Key name: CONTINUATION_CHARACTER_ON_NEXT_LINE.

Description: If there is a continuation character, is it at the start of the line.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$FIELD_TERMINATION_CHARACTER_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$FIELD_TERMINATION_CHARACTER_STRING

Logical property on flat_file operator. Key name: FIELD_TERMINATION_CHARACTER.

Description: Character that separates the fields of a delimited file.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$FIELD_ENCLOSURE_CHARACTERS_STRING

public static final java.lang.String FLAT_FILE$SQLLOADER$FIELD_ENCLOSURE_CHARACTERS_STRING

Logical property on flat_file operator. Key name: FIELD_ENCLOSURE_CHARACTERS.

Description: Characters that wrap fields. Example ' or ".

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$RECORD_SIZE_INTEGER

public static final java.lang.String FLAT_FILE$SQLLOADER$RECORD_SIZE_INTEGER

Logical property on flat_file operator. Key name: RECORD_SIZE.

Description: Size of a fixed length record.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$CONCATENATE_RECORDS_INTEGER

public static final java.lang.String FLAT_FILE$SQLLOADER$CONCATENATE_RECORDS_INTEGER

Logical property on flat_file operator. Key name: CONCATENATE_RECORDS.

Description: Number of Physical Records per Logical Record.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$RECORD_TYPE_POSITION_INTEGER

public static final java.lang.String FLAT_FILE$SQLLOADER$RECORD_TYPE_POSITION_INTEGER

Logical property on flat_file operator. Key name: RECORD_TYPE_POSITION.

Description: If this is a multi record file, this will indicate the position of the field that identifies the type of record.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$RECORD_TYPE_LENGTH_INTEGER

public static final java.lang.String FLAT_FILE$SQLLOADER$RECORD_TYPE_LENGTH_INTEGER

Logical property on flat_file operator. Key name: RECORD_TYPE_LENGTH.

Description: If this is a multi record file, this will indicate the length of the data that identifies the type of record. It is used with the Record Type Position.

See Also:

Constant Field Values

FLAT_FILE$SQLLOADER$FIELD_NAMES_IN_THE_FIRST_ROW_BOOLEAN

public static final java.lang.String FLAT_FILE$SQLLOADER$FIELD_NAMES_IN_THE_FIRST_ROW_BOOLEAN

Logical property on flat_file operator. Key name: FIELD_NAMES_IN_THE_FIRST_ROW.

Description: Indicates whether to write the field names in the first row of the output file.

See Also:

Constant Field Values

SET_OPERATION$SQL$SET_OPERATION_STRING

public static final java.lang.String SET_OPERATION$SQL$SET_OPERATION_STRING

Logical property on set_operation operator. Key name: SET_OPERATION.

Description: Specifies the set operation that is to be performed by this operator.

See Also:

Constant Field Values

KEY_LOOKUP$SQL$BOUND_NAME_STRING

public static final java.lang.String KEY_LOOKUP$SQL$BOUND_NAME_STRING

Logical property on key_lookup operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

KEY_LOOKUP$SQL$KEYS_READONLY_ML1LIST

public static final java.lang.String KEY_LOOKUP$SQL$KEYS_READONLY_ML1LIST

Logical property on key_lookup operator. Key name: KEYS_READONLY.

Description: None.

See Also:

Constant Field Values

KEY_LOOKUP$SQL$LOOKUP_CONDITION_STRING

public static final java.lang.String KEY_LOOKUP$SQL$LOOKUP_CONDITION_STRING

Logical property on key_lookup operator. Key name: LOOKUP_CONDITION.

Description: Key lookup condition based on the source inputs. This condition is used to lookup a value in the bound table. If the condition is not met, the default value expression will be returned. If a default expression is not defined, null is used.

See Also:

Constant Field Values

JOINER$SQL$JOIN_CONDITION_STRING

public static final java.lang.String JOINER$SQL$JOIN_CONDITION_STRING

Logical property on joiner operator. Key name: JOIN_CONDITION.

Description: The Join Condition for the join operator

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$BOUND_NAME_STRING

public static final java.lang.String MATERIALIZED_VIEW$SQL$BOUND_NAME_STRING

Logical property on materialized_view operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$PRIMARY_SOURCE_STRING

public static final java.lang.String MATERIALIZED_VIEW$SQL$PRIMARY_SOURCE_STRING

Logical property on materialized_view operator. Key name: PRIMARY_SOURCE.

Description: A boolean value to indicate whether this is a primary source or not (only used in EDW).

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$LOADING_TYPE_STRING

public static final java.lang.String MATERIALIZED_VIEW$SQL$LOADING_TYPE_STRING

Logical property on materialized_view operator. Key name: LOADING_TYPE.

Description: The loading operation to be performed when this is a target.

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$TARGET_FILTER_FOR_UPDATE_STRING

public static final java.lang.String MATERIALIZED_VIEW$SQL$TARGET_FILTER_FOR_UPDATE_STRING

Logical property on materialized_view operator. Key name: TARGET_FILTER_FOR_UPDATE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$TARGET_FILTER_FOR_DELETE_STRING

public static final java.lang.String MATERIALIZED_VIEW$SQL$TARGET_FILTER_FOR_DELETE_STRING

Logical property on materialized_view operator. Key name: TARGET_FILTER_FOR_DELETE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String MATERIALIZED_VIEW$SQL$MATCH_BY_CONSTRAINT_STRING

Logical property on materialized_view operator. Key name: MATCH_BY_CONSTRAINT.

Description: A property to indicate whether unique or primary key information on this target will override the matching criteria obtained from Match by constraint property on the attributes of this target.

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String MATERIALIZED_VIEW$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

Logical property on materialized_view operator. Key name: ADVANCED_MATCH_BY_CONSTRAINT.

Description: This property is used by public API and scripting to influence how columns are used for UPDATE or DELETE DMLs. If this property is set with the name of a primary or unique key, all the columns in the key will be used for matching during UPDATE or DELETE; and all the columns not in the key are used for loading. The property can also be assigned the value "All constraints" or "No constraints". If the DML type is INSERT, TRUNCATE/INSERT, or CHECK/INSERT, setting this property causes no effect.

See Also:

Constant Field Values

MATERIALIZED_VIEW$SQL$KEYS_READONLY_ML1LIST

public static final java.lang.String MATERIALIZED_VIEW$SQL$KEYS_READONLY_ML1LIST

Logical property on materialized_view operator. Key name: KEYS_READONLY.

Description: None.

See Also:

Constant Field Values

TABLE$SQL$BOUND_NAME_STRING

public static final java.lang.String TABLE$SQL$BOUND_NAME_STRING

Logical property on table operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

TABLE$SQL$PRIMARY_SOURCE_STRING

public static final java.lang.String TABLE$SQL$PRIMARY_SOURCE_STRING

Logical property on table operator. Key name: PRIMARY_SOURCE.

Description: A boolean value to indicate whether this is a primary source or not (only used in EDW).

See Also:

Constant Field Values

TABLE$SQL$LOADING_TYPE_STRING

public static final java.lang.String TABLE$SQL$LOADING_TYPE_STRING

Logical property on table operator. Key name: LOADING_TYPE.

Description: The loading operation to be performed when this is a target.

See Also:

Constant Field Values

TABLE$SQL$TARGET_FILTER_FOR_UPDATE_STRING

public static final java.lang.String TABLE$SQL$TARGET_FILTER_FOR_UPDATE_STRING

Logical property on table operator. Key name: TARGET_FILTER_FOR_UPDATE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.

See Also:

Constant Field Values

TABLE$SQL$TARGET_FILTER_FOR_DELETE_STRING

public static final java.lang.String TABLE$SQL$TARGET_FILTER_FOR_DELETE_STRING

Logical property on table operator. Key name: TARGET_FILTER_FOR_DELETE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.

See Also:

Constant Field Values

TABLE$SQL$MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String TABLE$SQL$MATCH_BY_CONSTRAINT_STRING

Logical property on table operator. Key name: MATCH_BY_CONSTRAINT.

Description: A property to indicate whether unique or primary key information on this target will override the matching criteria obtained from Match by constraint property on the attributes of this target.

See Also:

Constant Field Values

TABLE$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String TABLE$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

Logical property on table operator. Key name: ADVANCED_MATCH_BY_CONSTRAINT.

Description: This property is used by public API and scripting to influence how columns are used for UPDATE or DELETE DMLs. If this property is set with the name of a primary or unique key, all the columns in the key will be used for matching during UPDATE or DELETE; and all the columns not in the key are used for loading. The property can also be assigned the value "All constraints" or "No constraints". If the DML type is INSERT, TRUNCATE/INSERT, or CHECK/INSERT, setting this property causes no effect.

See Also:

Constant Field Values

TABLE$SQL$KEYS_READONLY_ML1LIST

public static final java.lang.String TABLE$SQL$KEYS_READONLY_ML1LIST

Logical property on table operator. Key name: KEYS_READONLY.

Description: None.

See Also:

Constant Field Values

POSTMAPPING_PROCESS$SQL$FUNCTION_NAME_STRING

public static final java.lang.String POSTMAPPING_PROCESS$SQL$FUNCTION_NAME_STRING

Logical property on postmapping_process operator. Key name: FUNCTION_NAME.

Description: Name of the transformation to be called.

See Also:

Constant Field Values

POSTMAPPING_PROCESS$SQL$FUNCTION_CALL_STRING

public static final java.lang.String POSTMAPPING_PROCESS$SQL$FUNCTION_CALL_STRING

Logical property on postmapping_process operator. Key name: FUNCTION_CALL.

Description: Expression template for procedure call

See Also:

Constant Field Values

POSTMAPPING_PROCESS$SQL$ROWBASED_ONLY_BOOLEAN

public static final java.lang.String POSTMAPPING_PROCESS$SQL$ROWBASED_ONLY_BOOLEAN

Logical property on postmapping_process operator. Key name: ROWBASED_ONLY.

Description: Indicates if this transformation must be used only Row Based mode. Some transformations can be used in SQL mode as well as Row Based mode.

See Also:

Constant Field Values

POSTMAPPING_PROCESS$SQL$POSTMAPPING_PROCESS_RUN_CONDITION_STRING

public static final java.lang.String POSTMAPPING_PROCESS$SQL$POSTMAPPING_PROCESS_RUN_CONDITION_STRING

Logical property on postmapping_process operator. Key name: POSTMAPPING_PROCESS_RUN_CONDITION.

Description: Indicates under what condition of the mapping the post-mapping process will be run.

See Also:

Constant Field Values

TRANSFORMATION$SQL$FUNCTION_NAME_STRING

public static final java.lang.String TRANSFORMATION$SQL$FUNCTION_NAME_STRING

Logical property on transformation operator. Key name: FUNCTION_NAME.

Description: Name of the transformation to be called.

See Also:

Constant Field Values

TRANSFORMATION$SQL$ROWBASED_ONLY_BOOLEAN

public static final java.lang.String TRANSFORMATION$SQL$ROWBASED_ONLY_BOOLEAN

Logical property on transformation operator. Key name: ROWBASED_ONLY.

Description: Indicates if this transformation must be used only Row Based mode. Some transformations can be used in SQL mode as well as Row Based mode.

See Also:

Constant Field Values

VIEW$SQL$BOUND_NAME_STRING

public static final java.lang.String VIEW$SQL$BOUND_NAME_STRING

Logical property on view operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

VIEW$SQL$PRIMARY_SOURCE_STRING

public static final java.lang.String VIEW$SQL$PRIMARY_SOURCE_STRING

Logical property on view operator. Key name: PRIMARY_SOURCE.

Description: A boolean value to indicate whether this is a primary source or not (only used in EDW).

See Also:

Constant Field Values

VIEW$SQL$LOADING_TYPE_STRING

public static final java.lang.String VIEW$SQL$LOADING_TYPE_STRING

Logical property on view operator. Key name: LOADING_TYPE.

Description: The loading operation to be performed when this is a target.

See Also:

Constant Field Values

VIEW$SQL$TARGET_FILTER_FOR_UPDATE_STRING

public static final java.lang.String VIEW$SQL$TARGET_FILTER_FOR_UPDATE_STRING

Logical property on view operator. Key name: TARGET_FILTER_FOR_UPDATE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.

See Also:

Constant Field Values

VIEW$SQL$TARGET_FILTER_FOR_DELETE_STRING

public static final java.lang.String VIEW$SQL$TARGET_FILTER_FOR_DELETE_STRING

Logical property on view operator. Key name: TARGET_FILTER_FOR_DELETE.

Description: A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.

See Also:

Constant Field Values

VIEW$SQL$MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String VIEW$SQL$MATCH_BY_CONSTRAINT_STRING

Logical property on view operator. Key name: MATCH_BY_CONSTRAINT.

Description: A property to indicate whether unique or primary key information on this target will override the matching criteria obtained from Match by constraint property on the attributes of this target.

See Also:

Constant Field Values

VIEW$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

public static final java.lang.String VIEW$SQL$ADVANCED_MATCH_BY_CONSTRAINT_STRING

Logical property on view operator. Key name: ADVANCED_MATCH_BY_CONSTRAINT.

Description: This property is used by public API and scripting to influence how columns are used for UPDATE or DELETE DMLs. If this property is set with the name of a primary or unique key, all the columns in the key will be used for matching during UPDATE or DELETE; and all the columns not in the key are used for loading. The property can also be assigned the value "All constraints" or "No constraints". If the DML type is INSERT, TRUNCATE/INSERT, or CHECK/INSERT, setting this property causes no effect.

See Also:

Constant Field Values

VIEW$SQL$KEYS_READONLY_ML1LIST

public static final java.lang.String VIEW$SQL$KEYS_READONLY_ML1LIST

Logical property on view operator. Key name: KEYS_READONLY.

Description: None.

See Also:

Constant Field Values

SEQUENCE$SQL$BOUND_NAME_STRING

public static final java.lang.String SEQUENCE$SQL$BOUND_NAME_STRING

Logical property on sequence operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

EXTERNAL_TABLE$SQL$BOUND_NAME_STRING

public static final java.lang.String EXTERNAL_TABLE$SQL$BOUND_NAME_STRING

Logical property on external_table operator. Key name: BOUND_NAME.

Description: The name to be used by the code generator to identify this item. By default it is the same physical name as the item.

See Also:

Constant Field Values

EXTERNAL_TABLE$SQL$PRIMARY_SOURCE_STRING

public static final java.lang.String EXTERNAL_TABLE$SQL$PRIMARY_SOURCE_STRING

Logical property on external_table operator. Key name: PRIMARY_SOURCE.

Description: A boolean value to indicate whether this is a primary source or not (only used in EDW).

See Also:

Constant Field Values

Constructor Detail

PropDefOperatorLogical

public PropDefOperatorLogical()

Method Detail

getPropSheet

protected static oracle.owb.mapping.PropSheetImpl getPropSheet(java.lang.String type)

getPropSheet Retrieve the property sheet of a property type.

Parameters:

type - A property type.

Returns:

The property sheet of the type.

containsKey

protected static boolean containsKey(java.lang.String type,
                                     java.lang.String key)

containsKey is a boolean checkup to see if this set of property definitions includes the definition for the key.

Parameters:

type - A property type.

key - A property key.

Returns:

true - if this set of properties defines the key; false - if otherwise.