Oracle Warehouse Builder Java API Reference
10g Release 1 (10.1)

B12155-01

oracle.owb.mapping
Class PropDefAttributeLogical

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

public class PropDefAttributeLogical
extends PropDefCommon

PropDefAttributeLogical defines all attribute logical properties.


Field Summary
static java.lang.String ADVANCED_QUEUE$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of advanced_queue operator.
static java.lang.String AGGREGATOR$OUTPUT$SQL$EXPRESSION_STRING
          Logical property on output attribute of aggregator operator.
static java.lang.String CONSTANT$OUTPUT$SQL$EXPRESSION_STRING
          Logical property on output attribute of constant operator.
static java.lang.String CUBE$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of cube operator.
static java.lang.String CUBE$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
          Logical property on in/out attribute of cube operator.
static java.lang.String CUBE$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of cube operator.
static java.lang.String CUBE$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
          Logical property on in/out attribute of cube operator.
static java.lang.String CUBE$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of cube operator.
static java.lang.String CUBE$INOUT$SQL$UPDATE_OPERATION_STRING
          Logical property on in/out attribute of cube operator.
static java.lang.String DATA_GENERATOR$OUTPUT$SQL$EXPRESSION_STRING
          Logical property on output attribute of data_generator operator.
static java.lang.String DIMENSION$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of dimension operator.
static java.lang.String DIMENSION$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
          Logical property on in/out attribute of dimension operator.
static java.lang.String DIMENSION$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of dimension operator.
static java.lang.String DIMENSION$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
          Logical property on in/out attribute of dimension operator.
static java.lang.String DIMENSION$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of dimension operator.
static java.lang.String DIMENSION$INOUT$SQL$UPDATE_OPERATION_STRING
          Logical property on in/out attribute of dimension operator.
static java.lang.String EXPRESSION$OUTPUT$SQL$EXPRESSION_STRING
          Logical property on output attribute of expression operator.
static java.lang.String EXTERNAL_TABLE$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of external_table operator.
static java.lang.String INPUT_PARAMETER$OUTPUT$SQL$DEFAULT_VALUE_STRING
          Logical property on output attribute of input_parameter operator.
static java.lang.String JOINER$OUTPUT$SQL$EXPRESSION_STRING
          Logical property on output attribute of joiner operator.
static java.lang.String KEY_LOOKUP$OUTPUT$SQL$BOUND_NAME_STRING
          Logical property on output attribute of key_lookup operator.
static java.lang.String KEY_LOOKUP$OUTPUT$SQL$DEFAULT_VALUE_STRING
          Logical property on output attribute of key_lookup operator.
static java.lang.String MATCHMERGE$OUTPUT$SQL$MERGE_ATTR_STRING
          Logical property on output attribute of matchmerge operator.
static java.lang.String MATERIALIZED_VIEW$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of materialized_view operator.
static java.lang.String MATERIALIZED_VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
          Logical property on in/out attribute of materialized_view operator.
static java.lang.String MATERIALIZED_VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of materialized_view operator.
static java.lang.String MATERIALIZED_VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
          Logical property on in/out attribute of materialized_view operator.
static java.lang.String MATERIALIZED_VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of materialized_view operator.
static java.lang.String MATERIALIZED_VIEW$INOUT$SQL$UPDATE_OPERATION_STRING
          Logical property on in/out attribute of materialized_view operator.
static java.lang.String NAME_AND_ADDRESS$INPUT$PLSQL$INPUT_ROLE_STRING
          Logical property on input attribute of name_and_address operator.
static java.lang.String NAME_AND_ADDRESS$OUTPUT$PLSQL$ADDRESS_TYPE_STRING
          Logical property on output attribute of name_and_address operator.
static java.lang.String NAME_AND_ADDRESS$OUTPUT$PLSQL$INSTANCE_STRING
          Logical property on output attribute of name_and_address operator.
static java.lang.String NAME_AND_ADDRESS$OUTPUT$PLSQL$OUTPUT_COMPONENT_STRING
          Logical property on output attribute of name_and_address operator.
static java.lang.String PIVOT$INPUT$SQL$GROUP_KEY_BOOLEAN
          Logical property on input attribute of pivot operator.
static java.lang.String PIVOT$OUTPUT$SQL$GROUP_KEY_BOOLEAN
          Logical property on output attribute of pivot operator.
static java.lang.String PIVOT$OUTPUT$SQL$PIVOT_EXPRESSION_STRING
          Logical property on output attribute of pivot operator.
static java.lang.String POSTMAPPING_PROCESS$INPUT$SQL$BOUND_NAME_STRING
          Logical property on input attribute of postmapping_process operator.
static java.lang.String POSTMAPPING_PROCESS$INPUT$SQL$DEFAULT_VALUE_STRING
          Logical property on input attribute of postmapping_process operator.
static java.lang.String POSTMAPPING_PROCESS$INPUT$SQL$IS_OPTIONAL_BOOLEAN
          Logical property on input attribute of postmapping_process operator.
static java.lang.String POSTMAPPING_PROCESS$OUTPUT$SQL$BOUND_NAME_STRING
          Logical property on output attribute of postmapping_process operator.
static java.lang.String POSTMAPPING_PROCESS$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN
          Logical property on output attribute of postmapping_process operator.
static java.lang.String PREMAPPING_PROCESS$INPUT$SQL$BOUND_NAME_STRING
          Logical property on input attribute of premapping_process operator.
static java.lang.String PREMAPPING_PROCESS$INPUT$SQL$DEFAULT_VALUE_STRING
          Logical property on input attribute of premapping_process operator.
static java.lang.String PREMAPPING_PROCESS$INPUT$SQL$IS_OPTIONAL_BOOLEAN
          Logical property on input attribute of premapping_process operator.
static java.lang.String PREMAPPING_PROCESS$OUTPUT$SQL$BOUND_NAME_STRING
          Logical property on output attribute of premapping_process operator.
static java.lang.String PREMAPPING_PROCESS$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN
          Logical property on output attribute of premapping_process operator.
static java.lang.String TABLE_FUNCTION$INPUT$SQL$PARAMETER_POSITION_INTEGER
          Logical property on input attribute of table_function operator.
static java.lang.String TABLE_FUNCTION$OUTPUT$SQL$TYPE_ATTRIBUTE_NAME_STRING
          Logical property on output attribute of table_function operator.
static java.lang.String TABLE$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of table operator.
static java.lang.String TABLE$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
          Logical property on in/out attribute of table operator.
static java.lang.String TABLE$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of table operator.
static java.lang.String TABLE$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
          Logical property on in/out attribute of table operator.
static java.lang.String TABLE$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of table operator.
static java.lang.String TABLE$INOUT$SQL$UPDATE_OPERATION_STRING
          Logical property on in/out attribute of table operator.
static java.lang.String TRANSFORMATION$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of transformation operator.
static java.lang.String TRANSFORMATION$INPUT$SQL$BOUND_NAME_STRING
          Logical property on input attribute of transformation operator.
static java.lang.String TRANSFORMATION$INPUT$SQL$DEFAULT_VALUE_STRING
          Logical property on input attribute of transformation operator.
static java.lang.String TRANSFORMATION$INPUT$SQL$IS_OPTIONAL_BOOLEAN
          Logical property on input attribute of transformation operator.
static java.lang.String TRANSFORMATION$OUTPUT$SQL$BOUND_NAME_STRING
          Logical property on output attribute of transformation operator.
static java.lang.String TRANSFORMATION$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN
          Logical property on output attribute of transformation operator.
static java.lang.String UNPIVOT$INPUT$SQL$GROUP_KEY_BOOLEAN
          Logical property on input attribute of unpivot operator.
static java.lang.String UNPIVOT$OUTPUT$SQL$GROUP_KEY_BOOLEAN
          Logical property on output attribute of unpivot operator.
static java.lang.String UNPIVOT$OUTPUT$SQL$MATCHING_ROW_INTEGER
          Logical property on output attribute of unpivot operator.
static java.lang.String UNPIVOT$OUTPUT$SQL$UNPIVOT_EXPRESSION_STRING
          Logical property on output attribute of unpivot operator.
static java.lang.String VIEW$INOUT$SQL$BOUND_NAME_STRING
          Logical property on in/out attribute of view operator.
static java.lang.String VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
          Logical property on in/out attribute of view operator.
static java.lang.String VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of view operator.
static java.lang.String VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
          Logical property on in/out attribute of view operator.
static java.lang.String VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
          Logical property on in/out attribute of view operator.
static java.lang.String VIEW$INOUT$SQL$UPDATE_OPERATION_STRING
          Logical property on in/out attribute of 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
PropDefAttributeLogical()
           

 

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

EXTERNAL_TABLE$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String EXTERNAL_TABLE$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of 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

EXPRESSION$OUTPUT$SQL$EXPRESSION_STRING

public static final java.lang.String EXPRESSION$OUTPUT$SQL$EXPRESSION_STRING
Logical property on output attribute of expression operator. Key name: EXPRESSION.

Description: Value returned for this attribute. This value can be a simple value like 'mystring' or a complex expression like SUBSTR(INGRP1.ENAME, 1, 5). For joiner operator, this gives the input attribute and group to which this output attribute corresponds. This expression, if editable, can be entered by using the expression editor which is invoked by the '...' button in the expression field or by entering the string directly into this field.

See Also:
Constant Field Values

KEY_LOOKUP$OUTPUT$SQL$BOUND_NAME_STRING

public static final java.lang.String KEY_LOOKUP$OUTPUT$SQL$BOUND_NAME_STRING
Logical property on output attribute of 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$OUTPUT$SQL$DEFAULT_VALUE_STRING

public static final java.lang.String KEY_LOOKUP$OUTPUT$SQL$DEFAULT_VALUE_STRING
Logical property on output attribute of key_lookup operator. Key name: DEFAULT_VALUE.

Description: The default value used for this attribute if no key lookup table row exists for a given input row.

See Also:
Constant Field Values

PREMAPPING_PROCESS$OUTPUT$SQL$BOUND_NAME_STRING

public static final java.lang.String PREMAPPING_PROCESS$OUTPUT$SQL$BOUND_NAME_STRING
Logical property on output attribute of premapping_process 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

PREMAPPING_PROCESS$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN

public static final java.lang.String PREMAPPING_PROCESS$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN
Logical property on output attribute of premapping_process operator. Key name: FUNCTION_RETURN.

Description: Specifies whether this output is the return value of this function

See Also:
Constant Field Values

PIVOT$OUTPUT$SQL$GROUP_KEY_BOOLEAN

public static final java.lang.String PIVOT$OUTPUT$SQL$GROUP_KEY_BOOLEAN
Logical property on output attribute of pivot operator. Key name: GROUP_KEY.

Description: A boolean value to indicate whether this output attribute is a part of the pivot group key, which obtains its value from its corresponding input attribute.

See Also:
Constant Field Values

PIVOT$OUTPUT$SQL$PIVOT_EXPRESSION_STRING

public static final java.lang.String PIVOT$OUTPUT$SQL$PIVOT_EXPRESSION_STRING
Logical property on output attribute of pivot operator. Key name: PIVOT_EXPRESSION.

Description: A comma-separated expression that gives the input attribute to be used for each output row in the pivot group.

See Also:
Constant Field Values

PIVOT$INPUT$SQL$GROUP_KEY_BOOLEAN

public static final java.lang.String PIVOT$INPUT$SQL$GROUP_KEY_BOOLEAN
Logical property on input attribute of pivot operator. Key name: GROUP_KEY.

Description: A boolean value to indicate whether this output attribute is a part of the pivot group key, which obtains its value from its corresponding input attribute.

See Also:
Constant Field Values

UNPIVOT$INPUT$SQL$GROUP_KEY_BOOLEAN

public static final java.lang.String UNPIVOT$INPUT$SQL$GROUP_KEY_BOOLEAN
Logical property on input attribute of unpivot operator. Key name: GROUP_KEY.

Description: A boolean value to indicate whether this output attribute is a part of the pivot group key, which obtains its value from its corresponding input attribute.

See Also:
Constant Field Values

TRANSFORMATION$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String TRANSFORMATION$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of transformation 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

UNPIVOT$OUTPUT$SQL$GROUP_KEY_BOOLEAN

public static final java.lang.String UNPIVOT$OUTPUT$SQL$GROUP_KEY_BOOLEAN
Logical property on output attribute of unpivot operator. Key name: GROUP_KEY.

Description: A boolean value to indicate whether this output attribute is a part of the pivot group key, which obtains its value from its corresponding input attribute.

See Also:
Constant Field Values

UNPIVOT$OUTPUT$SQL$MATCHING_ROW_INTEGER

public static final java.lang.String UNPIVOT$OUTPUT$SQL$MATCHING_ROW_INTEGER
Logical property on output attribute of unpivot operator. Key name: MATCHING_ROW.

Description: An positive integer to indicate from which row within the unpivot group this output attribute obtains its data.

See Also:
Constant Field Values

UNPIVOT$OUTPUT$SQL$UNPIVOT_EXPRESSION_STRING

public static final java.lang.String UNPIVOT$OUTPUT$SQL$UNPIVOT_EXPRESSION_STRING
Logical property on output attribute of unpivot operator. Key name: UNPIVOT_EXPRESSION.

Description: An expression that gives the input attribute to be used as the output of this attribute.

See Also:
Constant Field Values

CONSTANT$OUTPUT$SQL$EXPRESSION_STRING

public static final java.lang.String CONSTANT$OUTPUT$SQL$EXPRESSION_STRING
Logical property on output attribute of constant operator. Key name: EXPRESSION.

Description: Value returned for this attribute. This value can be a simple value like 'mystring' or a complex expression like SUBSTR(INGRP1.ENAME, 1, 5). For joiner operator, this gives the input attribute and group to which this output attribute corresponds. This expression, if editable, can be entered by using the expression editor which is invoked by the '...' button in the expression field or by entering the string directly into this field.

See Also:
Constant Field Values

TRANSFORMATION$INPUT$SQL$BOUND_NAME_STRING

public static final java.lang.String TRANSFORMATION$INPUT$SQL$BOUND_NAME_STRING
Logical property on input attribute of transformation 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

TRANSFORMATION$INPUT$SQL$IS_OPTIONAL_BOOLEAN

public static final java.lang.String TRANSFORMATION$INPUT$SQL$IS_OPTIONAL_BOOLEAN
Logical property on input attribute of transformation operator. Key name: IS_OPTIONAL.

Description: If true, the input is not required to be connected

See Also:
Constant Field Values

TRANSFORMATION$INPUT$SQL$DEFAULT_VALUE_STRING

public static final java.lang.String TRANSFORMATION$INPUT$SQL$DEFAULT_VALUE_STRING
Logical property on input attribute of transformation operator. Key name: DEFAULT_VALUE.

Description: The default value used for this attribute if no key lookup table row exists for a given input row.

See Also:
Constant Field Values

POSTMAPPING_PROCESS$OUTPUT$SQL$BOUND_NAME_STRING

public static final java.lang.String POSTMAPPING_PROCESS$OUTPUT$SQL$BOUND_NAME_STRING
Logical property on output attribute of postmapping_process 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

POSTMAPPING_PROCESS$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN

public static final java.lang.String POSTMAPPING_PROCESS$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN
Logical property on output attribute of postmapping_process operator. Key name: FUNCTION_RETURN.

Description: Specifies whether this output is the return value of this function

See Also:
Constant Field Values

TABLE_FUNCTION$OUTPUT$SQL$TYPE_ATTRIBUTE_NAME_STRING

public static final java.lang.String TABLE_FUNCTION$OUTPUT$SQL$TYPE_ATTRIBUTE_NAME_STRING
Logical property on output attribute of table_function operator. Key name: TYPE_ATTRIBUTE_NAME.

Description: The name of the field of the PLS Record or attribute of the Object Type or column of the ROWTYPE that corresponds to this attribute. This property is not applicable if the return type is TABLE of SCALAR.

See Also:
Constant Field Values

VIEW$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String VIEW$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of 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$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING

public static final java.lang.String VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
Logical property on in/out attribute of view operator. Key name: LOAD_COLUMN_WHEN_INSERTING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the insert load operation.

See Also:
Constant Field Values

VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of view operator. Key name: LOAD_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the update load operation.

See Also:
Constant Field Values

VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of view operator. Key name: MATCH_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

VIEW$INOUT$SQL$UPDATE_OPERATION_STRING

public static final java.lang.String VIEW$INOUT$SQL$UPDATE_OPERATION_STRING
Logical property on in/out attribute of view operator. Key name: UPDATE_OPERATION.

Description: The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING

public static final java.lang.String VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
Logical property on in/out attribute of view operator. Key name: MATCH_COLUMN_WHEN_DELETING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the delete load operation.

See Also:
Constant Field Values

ADVANCED_QUEUE$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String ADVANCED_QUEUE$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of 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

DIMENSION$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String DIMENSION$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of 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$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING

public static final java.lang.String DIMENSION$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
Logical property on in/out attribute of dimension operator. Key name: LOAD_COLUMN_WHEN_INSERTING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the insert load operation.

See Also:
Constant Field Values

DIMENSION$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String DIMENSION$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of dimension operator. Key name: LOAD_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the update load operation.

See Also:
Constant Field Values

DIMENSION$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String DIMENSION$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of dimension operator. Key name: MATCH_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

DIMENSION$INOUT$SQL$UPDATE_OPERATION_STRING

public static final java.lang.String DIMENSION$INOUT$SQL$UPDATE_OPERATION_STRING
Logical property on in/out attribute of dimension operator. Key name: UPDATE_OPERATION.

Description: The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

DIMENSION$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING

public static final java.lang.String DIMENSION$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
Logical property on in/out attribute of dimension operator. Key name: MATCH_COLUMN_WHEN_DELETING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the delete load operation.

See Also:
Constant Field Values

DATA_GENERATOR$OUTPUT$SQL$EXPRESSION_STRING

public static final java.lang.String DATA_GENERATOR$OUTPUT$SQL$EXPRESSION_STRING
Logical property on output attribute of data_generator operator. Key name: EXPRESSION.

Description: Value returned for this attribute. This value can be a simple value like 'mystring' or a complex expression like SUBSTR(INGRP1.ENAME, 1, 5). For joiner operator, this gives the input attribute and group to which this output attribute corresponds. This expression, if editable, can be entered by using the expression editor which is invoked by the '...' button in the expression field or by entering the string directly into this field.

See Also:
Constant Field Values

JOINER$OUTPUT$SQL$EXPRESSION_STRING

public static final java.lang.String JOINER$OUTPUT$SQL$EXPRESSION_STRING
Logical property on output attribute of joiner operator. Key name: EXPRESSION.

Description: Value returned for this attribute. This value can be a simple value like 'mystring' or a complex expression like SUBSTR(INGRP1.ENAME, 1, 5). For joiner operator, this gives the input attribute and group to which this output attribute corresponds. This expression, if editable, can be entered by using the expression editor which is invoked by the '...' button in the expression field or by entering the string directly into this field.

See Also:
Constant Field Values

TABLE$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String TABLE$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of 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$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING

public static final java.lang.String TABLE$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
Logical property on in/out attribute of table operator. Key name: LOAD_COLUMN_WHEN_INSERTING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the insert load operation.

See Also:
Constant Field Values

TABLE$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String TABLE$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of table operator. Key name: LOAD_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the update load operation.

See Also:
Constant Field Values

TABLE$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String TABLE$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of table operator. Key name: MATCH_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

TABLE$INOUT$SQL$UPDATE_OPERATION_STRING

public static final java.lang.String TABLE$INOUT$SQL$UPDATE_OPERATION_STRING
Logical property on in/out attribute of table operator. Key name: UPDATE_OPERATION.

Description: The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

TABLE$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING

public static final java.lang.String TABLE$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
Logical property on in/out attribute of table operator. Key name: MATCH_COLUMN_WHEN_DELETING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the delete load operation.

See Also:
Constant Field Values

NAME_AND_ADDRESS$OUTPUT$PLSQL$OUTPUT_COMPONENT_STRING

public static final java.lang.String NAME_AND_ADDRESS$OUTPUT$PLSQL$OUTPUT_COMPONENT_STRING
Logical property on output attribute of name_and_address operator. Key name: OUTPUT_COMPONENT.

Description: Assigns a Name and Address output component to the selected output attribute.

See Also:
Constant Field Values

NAME_AND_ADDRESS$OUTPUT$PLSQL$ADDRESS_TYPE_STRING

public static final java.lang.String NAME_AND_ADDRESS$OUTPUT$PLSQL$ADDRESS_TYPE_STRING
Logical property on output attribute of name_and_address operator. Key name: ADDRESS_TYPE.

Description: You can designate an address type as Normal or Dual. For example, a dual address occurs when a record contains both a street address and a P.O. Box; this is common with business data. A normal address contains only one type of address.

See Also:
Constant Field Values

NAME_AND_ADDRESS$OUTPUT$PLSQL$INSTANCE_STRING

public static final java.lang.String NAME_AND_ADDRESS$OUTPUT$PLSQL$INSTANCE_STRING
Logical property on output attribute of name_and_address operator. Key name: INSTANCE.

Description: The instance option is used when an address contains multiple names, you can specify which name in the group should be used. In addition, you can use this option to assign an address type to a miscellaneous address component.

See Also:
Constant Field Values

POSTMAPPING_PROCESS$INPUT$SQL$BOUND_NAME_STRING

public static final java.lang.String POSTMAPPING_PROCESS$INPUT$SQL$BOUND_NAME_STRING
Logical property on input attribute of postmapping_process 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

POSTMAPPING_PROCESS$INPUT$SQL$IS_OPTIONAL_BOOLEAN

public static final java.lang.String POSTMAPPING_PROCESS$INPUT$SQL$IS_OPTIONAL_BOOLEAN
Logical property on input attribute of postmapping_process operator. Key name: IS_OPTIONAL.

Description: If true, the input is not required to be connected

See Also:
Constant Field Values

POSTMAPPING_PROCESS$INPUT$SQL$DEFAULT_VALUE_STRING

public static final java.lang.String POSTMAPPING_PROCESS$INPUT$SQL$DEFAULT_VALUE_STRING
Logical property on input attribute of postmapping_process operator. Key name: DEFAULT_VALUE.

Description: The default value used for this attribute if no key lookup table row exists for a given input row.

See Also:
Constant Field Values

TRANSFORMATION$OUTPUT$SQL$BOUND_NAME_STRING

public static final java.lang.String TRANSFORMATION$OUTPUT$SQL$BOUND_NAME_STRING
Logical property on output attribute of transformation 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

TRANSFORMATION$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN

public static final java.lang.String TRANSFORMATION$OUTPUT$SQL$FUNCTION_RETURN_BOOLEAN
Logical property on output attribute of transformation operator. Key name: FUNCTION_RETURN.

Description: Specifies whether this output is the return value of this function

See Also:
Constant Field Values

AGGREGATOR$OUTPUT$SQL$EXPRESSION_STRING

public static final java.lang.String AGGREGATOR$OUTPUT$SQL$EXPRESSION_STRING
Logical property on output attribute of aggregator operator. Key name: EXPRESSION.

Description: Value returned for this attribute. This value can be a simple value like 'mystring' or a complex expression like SUBSTR(INGRP1.ENAME, 1, 5). For joiner operator, this gives the input attribute and group to which this output attribute corresponds. This expression, if editable, can be entered by using the expression editor which is invoked by the '...' button in the expression field or by entering the string directly into this field.

See Also:
Constant Field Values

NAME_AND_ADDRESS$INPUT$PLSQL$INPUT_ROLE_STRING

public static final java.lang.String NAME_AND_ADDRESS$INPUT$PLSQL$INPUT_ROLE_STRING
Logical property on input attribute of name_and_address operator. Key name: INPUT_ROLE.

Description: Assigns a name-address input role to the selected input attribute

See Also:
Constant Field Values

INPUT_PARAMETER$OUTPUT$SQL$DEFAULT_VALUE_STRING

public static final java.lang.String INPUT_PARAMETER$OUTPUT$SQL$DEFAULT_VALUE_STRING
Logical property on output attribute of input_parameter operator. Key name: DEFAULT_VALUE.

Description: The default value used for this attribute if no key lookup table row exists for a given input row.

See Also:
Constant Field Values

CUBE$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String CUBE$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of 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$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING

public static final java.lang.String CUBE$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
Logical property on in/out attribute of cube operator. Key name: LOAD_COLUMN_WHEN_INSERTING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the insert load operation.

See Also:
Constant Field Values

CUBE$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String CUBE$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of cube operator. Key name: LOAD_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the update load operation.

See Also:
Constant Field Values

CUBE$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String CUBE$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of cube operator. Key name: MATCH_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

CUBE$INOUT$SQL$UPDATE_OPERATION_STRING

public static final java.lang.String CUBE$INOUT$SQL$UPDATE_OPERATION_STRING
Logical property on in/out attribute of cube operator. Key name: UPDATE_OPERATION.

Description: The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

CUBE$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING

public static final java.lang.String CUBE$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
Logical property on in/out attribute of cube operator. Key name: MATCH_COLUMN_WHEN_DELETING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the delete load operation.

See Also:
Constant Field Values

MATCHMERGE$OUTPUT$SQL$MERGE_ATTR_STRING

public static final java.lang.String MATCHMERGE$OUTPUT$SQL$MERGE_ATTR_STRING
Logical property on output attribute of matchmerge operator. Key name: MERGE_ATTR.

Description: Related merge attribute

See Also:
Constant Field Values

MATERIALIZED_VIEW$INOUT$SQL$BOUND_NAME_STRING

public static final java.lang.String MATERIALIZED_VIEW$INOUT$SQL$BOUND_NAME_STRING
Logical property on in/out attribute of 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$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING

public static final java.lang.String MATERIALIZED_VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_INSERTING_ROW_STRING
Logical property on in/out attribute of materialized_view operator. Key name: LOAD_COLUMN_WHEN_INSERTING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the insert load operation.

See Also:
Constant Field Values

MATERIALIZED_VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String MATERIALIZED_VIEW$INOUT$SQL$LOAD_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of materialized_view operator. Key name: LOAD_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will particiate in the update load operation.

See Also:
Constant Field Values

MATERIALIZED_VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING

public static final java.lang.String MATERIALIZED_VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_UPDATING_ROW_STRING
Logical property on in/out attribute of materialized_view operator. Key name: MATCH_COLUMN_WHEN_UPDATING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

MATERIALIZED_VIEW$INOUT$SQL$UPDATE_OPERATION_STRING

public static final java.lang.String MATERIALIZED_VIEW$INOUT$SQL$UPDATE_OPERATION_STRING
Logical property on in/out attribute of materialized_view operator. Key name: UPDATE_OPERATION.

Description: The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.

See Also:
Constant Field Values

MATERIALIZED_VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING

public static final java.lang.String MATERIALIZED_VIEW$INOUT$SQL$MATCH_COLUMN_WHEN_DELETING_ROW_STRING
Logical property on in/out attribute of materialized_view operator. Key name: MATCH_COLUMN_WHEN_DELETING_ROW.

Description: A boolean value to indicate whether this attribute will be used to construct the matching criteria between the incoming data and the existing data on the target during the delete load operation.

See Also:
Constant Field Values

TABLE_FUNCTION$INPUT$SQL$PARAMETER_POSITION_INTEGER

public static final java.lang.String TABLE_FUNCTION$INPUT$SQL$PARAMETER_POSITION_INTEGER
Logical property on input attribute of table_function operator. Key name: PARAMETER_POSITION.

Description: The position of the argument in the table function signature corresponding to this parmater

See Also:
Constant Field Values

PREMAPPING_PROCESS$INPUT$SQL$BOUND_NAME_STRING

public static final java.lang.String PREMAPPING_PROCESS$INPUT$SQL$BOUND_NAME_STRING
Logical property on input attribute of premapping_process 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

PREMAPPING_PROCESS$INPUT$SQL$IS_OPTIONAL_BOOLEAN

public static final java.lang.String PREMAPPING_PROCESS$INPUT$SQL$IS_OPTIONAL_BOOLEAN
Logical property on input attribute of premapping_process operator. Key name: IS_OPTIONAL.

Description: If true, the input is not required to be connected

See Also:
Constant Field Values

PREMAPPING_PROCESS$INPUT$SQL$DEFAULT_VALUE_STRING

public static final java.lang.String PREMAPPING_PROCESS$INPUT$SQL$DEFAULT_VALUE_STRING
Logical property on input attribute of premapping_process operator. Key name: DEFAULT_VALUE.

Description: The default value used for this attribute if no key lookup table row exists for a given input row.

See Also:
Constant Field Values
Constructor Detail

PropDefAttributeLogical

public PropDefAttributeLogical()
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.

Oracle Warehouse Builder Java API Reference
10g Release 1 (10.1)

B12155-01

Copyright © 2003, Oracle. All Rights Reserved.