Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES
SUMMARY:  INNER | FIELD | CONSTR | METHOD DETAIL:  FIELD | CONSTR | METHOD

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 ADVANCEDQUEUE$SQL$BOUND_NAME_STRING
          Logical property on advancedqueue 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
(package private) static void ()
           
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

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.

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.

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

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.

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.

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.

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.

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.

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

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

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

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

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

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.

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).

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.

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.

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.

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.

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.

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.

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.

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).

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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

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

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

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.

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

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.

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.

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

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.

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

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).

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.

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.

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.

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.

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 ".

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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).

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.

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.

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.

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.

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.

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.

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.

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).

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

ADVANCEDQUEUE$SQL$BOUND_NAME_STRING

public static final java.lang.String ADVANCEDQUEUE$SQL$BOUND_NAME_STRING
Logical property on advancedqueue 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.

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.

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).

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.

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.

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.

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.

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.

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.

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.

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.

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).

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.

static void ()
Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES
SUMMARY:  INNER | FIELD | CONSTR | METHOD DETAIL:  FIELD | CONSTR | METHOD