OMBCREATE MAPPING

Purpose

Create a mapping in an Oracle Module.

Prerequisites

1. The current context of scripting must be an Oracle Module.

2. No concurrent user should be locking the Oracle Module or any of its ancestors exclusively at the moment the map is being created.

3. The map name must not conflict with existing map names and the maps names that concurrent user tries to use.

4. The GENERATION_LANGUAGE property has to be set for configuration properties of the map can be set. The list of available configuration properties of map is determined by the GENERATION_LANGUAGE property.

Syntax

createMappingCommand =  OMBCREATE MAPPING "mappingName" ( [ AS ( 
          TRICKLE_FEED_MAPPING | BATCH_MAPPING ) ] ) [ 
          "createOperatorOwnerDetailClause" ]
     mappingName =  "QUOTED_STRING"
     createOperatorOwnerDetailClause =  ( 
          "createOperatorOwnerPropertiesCTClause" [ 
          "createOperatorOwnerDescendantsClause" ] ) | 
          "createOperatorOwnerDescendantsClause"
     createOperatorOwnerPropertiesCTClause =  SET ( ( "setPropertiesClause" [ ( 
          SET "setCodeTemplateClause" [ SET "setReferenceIconSetClause" ] ) | ( 
          SET "setControlCodeTemplateClause" [ SET "setReferenceIconSetClause" ]
           ) | SET "setReferenceIconSetClause" ] ) | ( "setCodeTemplateClause" [
           SET "setReferenceIconSetClause" ] ) | ( 
          "setControlCodeTemplateClause" [ SET "setReferenceIconSetClause" ] ) |
           "setReferenceIconSetClause" )
     createOperatorOwnerDescendantsClause =  ( ADD ( "addOperatorClause" | 
          "addGroupClause" | "addAttributeClause" | "addChildClause" | 
          "addConnectionClause" | "addExecutionUnitClause" ) )+ [ 
          "setDefaultExecutionUnitClause" ]
     setPropertiesClause =  PROPERTIES "propertyKeyList" VALUES 
          "propertyValueList"
     setCodeTemplateClause =  ( REFERENCE | REF ) CODE_TEMPLATE "QUOTED_STRING" 
          | ( ( REFERENCE | REF ) CODE_TEMPLATE OPTIONS "(" "optionValueList" 
          ")" VALUES "(" "optionValueList" ")" )
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     setControlCodeTemplateClause =  ( REFERENCE | REF ) CONTROL_CODE_TEMPLATE 
          "QUOTED_STRING" | ( ( REFERENCE | REF ) CONTROL_CODE_TEMPLATE OPTIONS 
          "(" "optionValueList" ")" VALUES "(" "optionValueList" ")" )
     addOperatorClause =  "operatorType" OPERATOR "operatorName" [ 
          "pluggableMapBottomUpLocator" ] [ SET "setPropertiesClause" ] [ 
          "setBindingClause" ]
     addGroupClause =  "groupDirection" GROUP "groupName" OF 
          "operatorBottomUpLocator" [ SET "setPropertiesClause" ] [ 
          "setBindingClause" ] [ "internallyConnectToClause" ]
     addAttributeClause =  ATTRIBUTE "attributeName" OF "groupBottomUpLocator" [
           SET "setPropertiesClause" ]
     addChildClause =  "childType" "childName" "childOwnerBottomUpLocator" [ SET
           "setPropertiesClause" ]
     addConnectionClause =  CONNECTION FROM ( "groupBottomUpLocator" TO 
          "groupBottomUpLocator" [ "groupToGroupConnectType" ] | 
          "attributeBottomUpLocator" TO ( "attributeBottomUpLocator" | 
          "attributesBottomUpLocator" | "groupBottomUpLocator" ) | 
          "attributesBottomUpLocator" TO ( "attributesBottomUpLocator" | 
          "groupBottomUpLocator" ) )
     addExecutionUnitClause =  EXECUTION_UNIT "executionUnitName" OPERATORS 
          "operatorNameList" [ SET ( REFERENCE | REF ) CODE_TEMPLATE 
          "setEUCodeTemplateClause" ] [ SET ( REFERENCE | REF ) 
          CONTROL_CODE_TEMPLATE "setEUControlCodeTemplateClause" ]
     setDefaultExecutionUnitClause =  SET DEFAULT_EXECUTION_UNIT
     propertyKeyList =  "(" "propertyKey" { "," "propertyKey" } ")"
     propertyValueList =  "(" "propertyValue" { "," "propertyValue" } ")"
     optionValueList =  "propertyValue" { "," "propertyValue" }
     operatorType =  PLUGGABLE_MAPPING | "UNQUOTED_STRING"
     operatorName =  "QUOTED_STRING"
     pluggableMapBottomUpLocator =  ( OF PLUGGABLE_MAPPING "pluggableMapName" [ 
          "pluggableMapBottomUpLocator" ] )
     setBindingClause =  BOUND TO "bindableLocator"
     groupDirection =  INPUT | OUTPUT | INPUT_OUTPUT
     groupName =  "QUOTED_STRING"
     operatorBottomUpLocator =  OPERATOR "operatorName" [ 
          "pluggableMapBottomUpLocator" ]
     internallyConnectToClause =  SET REF "groupLocator"
     attributeName =  "QUOTED_STRING"
     groupBottomUpLocator =  GROUP "groupName" OF "operatorBottomUpLocator"
     childType =  "UNQUOTED_STRING"
     childName =  "QUOTED_STRING"
     childOwnerBottomUpLocator =  { OF "childType" "childName" } [ OF 
          "mappableBottomUpLocator" ]
     groupToGroupConnectType =  COPY ALL | BY ( NAME [ IGNORE ( SPECIAL_CHARS 
          "QUOTED_STRING" | SOURCE_PREFIX "QUOTED_STRING" | SOURCE_SUFFIX 
          "QUOTED_STRING" | TARGET_PREFIX "QUOTED_STRING" | TARGET_SUFFIX 
          "QUOTED_STRING" ) { "," IGNORE ( SPECIAL_CHARS "QUOTED_STRING" | 
          SOURCE_PREFIX "QUOTED_STRING" | SOURCE_SUFFIX "QUOTED_STRING" | 
          TARGET_PREFIX "QUOTED_STRING" | TARGET_SUFFIX "QUOTED_STRING" ) } ] | 
          POSITION )
     attributeBottomUpLocator =  ATTRIBUTE "attributeName" OF 
          "groupBottomUpLocator"
     attributesBottomUpLocator =  ATTRIBUTES "attributeNameList" OF 
          "groupBottomUpLocator"
     executionUnitName =  "QUOTED_STRING"
     operatorNameList =  "(" "operatorName" { "," "operatorName" } ")"
     setEUCodeTemplateClause =  "QUOTED_STRING" | OPTIONS "(" "optionValueList" 
          ")" VALUES "(" "optionValueList" ")"
     setEUControlCodeTemplateClause =  "QUOTED_STRING" | OPTIONS "(" 
          "optionValueList" ")" VALUES "(" "optionValueList" ")"
     propertyKey =  "UNQUOTED_STRING" | FILE_FORMAT
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     pluggableMapName =  "QUOTED_STRING"
     bindableLocator =  "bindableType" "bindableName" [ OF "bindableType" 
          "bindableName" ]
     groupLocator =  GROUP "groupName"
     mappableBottomUpLocator =  "operatorBottomUpLocator" | 
          "groupBottomUpLocator" | "attributeBottomUpLocator"
     attributeNameList =  "(" "attributeName" { "," "attributeName" } ")"
     bindableType =  PLUGGABLE_MAPPING | OBJECT_TYPE | "UNQUOTED_STRING"
     bindableName =  "QUOTED_STRING"

Parameters

createMappingCommand

Create a mapping in an Oracle Module.

mappingName

Name of the mapping.

createOperatorOwnerDetailClause

Create the desired detail of a pluggable mapping.

createOperatorOwnerPropertiesCTClause

Describe the properties, code template or icon set settings in the map.

createOperatorOwnerDescendantsClause

Create the desired child objects of a mapping or a pluggable mapping.

setPropertiesClause

Describe the keys of properties for the map or objects in the map.

setReferenceIconSetClause

Set icon set for the map.

addOperatorClause

Adds a mapping operator to a map. When you add an operator, Warehouse Builder creates default groups and parameters for the operator. Please see the appendix section of the Scripting Reference.

The following is an example for creating an operator:

OMBALTER MAPPING 'M1' ADD TABLE OPERATOR 'T1'

addGroupClause

Add a mapping group to a mapping operator.

addAttributeClause

Add a mapping attribute to a mapping group.

addChildClause

Add a child to a mapping, mapping operator, mapping group or mapping attribute.

The following is an example for creating a child object under a mapping

OMBALTER MAPPING 'M1' ADD SOURCE_DATA_FILE 'FILE1'

Note: Key word "OPERATOR" "GROUP" "ATTRIBUTE" are important for their respective ADD clauses. Without the key words, OMBPlus will interpret the ADD clause as an addChildClause. Here is an example:

OMB+> OMBALTER MAPPING 'M1' ADD TABLE 'T1'

OMB02932: Error getting child objects of type TABLE in M1

OMBPLUS interprets the ADD clause as one for creating a non-operator child object under the mapping object. Therefore, it tries to find type definition for non-operator child object "TABLE" and cannot find it.

addConnectionClause

Add connections between mapping groups or mapping attributes.

addExecutionUnitClause

Create the execution unit, the operators it contains, and the code template used to implement the logic represented by the execution unit.

setDefaultExecutionUnitClause

Create execution units for the map and assign code templates to the execution units based on a predefined algorithm.

propertyKeyList

The list of property keys.

propertyValueList

A list of property values.

optionValueList

Describe the list of option names or the option values for the code template.

operatorType

Type of a mapping operator. The following operator types are available: ADVANCED_QUEUE, AGGREGATOR, ANYDATA_CAST, CONSTANT, CONSTRUCT_OBJECT, CUBE, DATA_GENERATOR, DEDUPLICATOR, DIMENSION, EXPAND_OBJECT, EXPRESSION, EXTERNAL_TABLE, FILTER, FLAT_FILE, INPUT_PARAMETER, INPUT_SIGNATURE, ITERATOROPERATOR, JOINER, KEY_LOOKUP, LCRCAST, LCRSPLITTER, MATCHMERGE, MATERIALIZED_VIEW, NAME_AND_ADDRESS, OUTPUT_PARAMETER, OUTPUT_SIGNATURE, PIVOT, PLUGGABLE_MAPPING, POSTMAPPING_PROCESS, PREMAPPING_PROCESS, SEQUENCE, SET_OPERATION, SORTER, SPLITTER, TABLE, TABLE_FUNCTION, TRANSFORMATION, UNPIVOT, VIEW.

operatorName

Name of a mapping operator.

pluggableMapBottomUpLocator

Location of a child pluggable mapping within a mapping or another pluggable mapping.

setBindingClause

Set the binding during the creation of a mapping operator or mapping attribute.

groupDirection

Direction of a mapping group.

groupName

Name of a mapping group.

operatorBottomUpLocator

Location of a mapping operator.

internallyConnectToClause

Specify the input attribute group that this output attribute group is associated with (for lookup operator).

attributeName

Name of a mapping attribute.

groupBottomUpLocator

Location of a mapping group.

childType

Type of a child that belongs to map, mapping operator, mapping group or mapping attribute.

childName

Name of a child that belongs to map, mapping operator, mapping group or mapping attribute.

childOwnerBottomUpLocator

Location of a child owner. A child owner can be a map, mapping operator, mapping group, mapping attribute or a child.

groupToGroupConnectType

Connecting from a mapping group in one mapping operator to a mapping group in another mapping operator.

attributeBottomUpLocator

Location of a mapping attribute.

attributesBottomUpLocator

Location of a list of mapping attributes.

executionUnitName

The name of the execution unit to be created, modified or deleted.

operatorNameList

Describe the list of operators to be contained in the execution unit.

propertyKey

A property key for an object.

propertyKey

Basic properties for MAPPING:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the mapping

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the mapping

Basic properties for OPERATOR:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the operator

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the operator

Basic properties for GROUP:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the group

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the group

Basic properties for ATTRIBUTE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the attribute

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the attribute

Name: DATATYPE
Type: STRING(20)
Valid Values: BINARY_DOUBLE, BINARY_FLOAT, BLOB, CHAR, CLOB, DATE, FLOAT, INTEGER, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, NCHAR, NCLOB, NUMBER, NVARCHAR2, RAW, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARHCAR, VARCHAR2, XMLTYPE
Default: Empty string
Datatype of the Attribute

Name: LENGTH
Type: NUMBER
Valid Values: Any valid character string in supported character set.
Default: 0
Length of the attribute.

Name: PRECISION
Type: NUMBER
Valid Values: Any valid character string in supported character set.
Default: 0
Precision of the attribute.

Name: SCALE
Type: NUMBER
Valid Values: Any valid character string in supported character set.
Default: 0
Scale of the attribute.

Name: FRACTIONAL_SECONDS_PRECISION
Type: NUMBER
Valid Values: 0 - 9
Default: 0
The precision of a timestamp or interval.
Basic properties for SQLPLUS Mapping:

Name: ARRAYSIZE
Type: NUMBER
Valid Values: Any valid character string in supported character set.
Default: 15
The default array size

Name: COPYCOMMIT
Type: NUMBER
Valid Values: Any valid character string in supported character set.
Default: 0
number of records copied before commit

Name: LONG_SIZE
Type: NUMBER
Valid Values: Any valid character string in supported character set.
Default: 2000000
The default long size

Name: SQL_FILE_DIRECTORY
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
SQL file directory

Name: SQL_FILE_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
SQL file name

Name: LOG_FILE_DIRECTORY
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
log file directory

Name: LOG_FILE_NAME_SQLPLUS
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
log file name

propertyValue

A single property value. It can be a number, float, boolean or single-quoted string.

pluggableMapName

Name of the pluggable map.

bindableLocator

Location of the object to be bound to a mapping operator or mapping attribute.

groupLocator

Location of a mapping group.

mappableBottomUpLocator

Location of the object to be bound to a mapping mapping operator or mapping attribute.

attributeNameList

A list of attribute names.

bindableType

Type of object bound to a mapping operator or mapping attribute.

bindableName

Name of the object bound to a mapping operator or mapping attribute.

MAPPING Object

Table 8-6 MAPPING Object

Property	Type	Choices	Min	Max	Default	Description
DEPLOYABLE	BOOLEAN	true, false	none	none	true	True if the map is deployable to a physical implementation
DIAGRAM_LAYOUT	STRING	none	none	none	empty string
EXECUTION_TYPE	STRING	BATCH, TRICKLE	none	none	BATCH	Batch if this map is to be executed in batch; Trickle if this map is to be executed as a real-time map.
GENERATION_COMMENTS	STRING	none	none	none	empty string	Enter additional comments for the generated code.
GENERATION_LANGUAGE	STRING	ABAP, PLSQL, SQLLOADER, UNDEFINED	none	none	UNDEFINED	The language used when generating code for the mapping.
MAX_CHUNK_ITERATOR_COUNT	NUMBER	none	none	none	50	The maximum number of chunking iterations allowed for this map, if chunking is switched on for any source.
REFERRED_CALENDAR	STRING	none	none	none	empty string	Enter the Schedule to associate with this object.
STOP_CHUNKING_IF_NO_DATA	BOOLEAN	true, false	none	none	true	Stop chunk processing if no rows are processed for a given chunk iterator value (serial chunking only).
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.

OPERATOR Object

Table 8-7 OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

GROUP Object

Table 8-8 GROUP Object

Property	Type	Choices	Min	Max	Default	Description
AW_LOAD_STAGETABLE_NAME	STRING	none	none	none	empty string	The stage table used to load the AW level
AW_LOAD_VIEW_NAME	STRING	none	none	none	empty string	The view used to load the AW level
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by reconciliation for this item. Unlike other operators, it is not needed for generation. By default it is the same name as the item.
CAST_SOURCE	STRING	none	none	none	empty string
COMMANDTYPE	STRING	ALL_COMMAND_TYPES, DELETE, INSERT, UPDATE	none	none	ALL_COMMAND_TYPES	The operation causing the change described by the LCR
CREATE_NO_MATCH_ROW	BOOLEAN	true, false	none	none	true	If true, a row is created and the user-defined default values are used, in the case where no lookup match is found. If false, no row is produced.
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DIMENSION_KEY	STRING(32)	none	none	none	empty string
DML_ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target for DML error logging.
DYNAMIC_LOOKUP_FILTER	STRING	none	none	none	empty string	A filter condition on lookup table.
ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target to log invalid records.
EXPRESSION_INOUT	STRING	none	none	none	empty string	Description not available.
EXPRESSION_OUT	STRING	none	none	none	empty string	Description not available.
EXTRACTION_HINT	STRING	none	none	none	empty string	Hint used when extracting from this table using SQL
IS_ERROR_GRP	BOOLEAN	true, false	none	none	false	Set if the group is associated with an error table.
IS_EXPANDED	BOOLEAN	true, false	none	none	true	Set if the operator is expanded in the UI (should be hidden)
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
JOIN_INPUT_ROLE	STRING(16)	OUTER, STANDARD	none	none	STANDARD	The role the input stream plays in the join.
KEY_NAMES	STRING	none	none	none	empty string	A comma separated list of unique keys used in the lookup condition for this output group.
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
LEVEL_BOUND_NAME	STRING	none	none	none	empty string	The bound name of this level.
LEVEL_BOUND_UOID	STRING	none	none	none	empty string
LEVEL_NAME	STRING	none	none	none	empty string	The full level name of the bound level
LEVEL_POSITION	STRING	LOWEST, MIDDLE, TOP	none	none	MIDDLE	The position of the level inside the hierarchies. The level will only be marked TOP or LOWEST if it is the top or lowest level in all hierarchies in which it participates.
LOOKUP_BOUND_OBJECT	STRING	none	none	none	empty string	The full name of the bound lookup object for the group.
LOOKUP_CONDITION	STRING	none	none	none	empty string	Lookup condition matching source inputs with lookup table. This condition is used to look up rows in the lookup table using values from the input group.
MCM_MATCH_VALUE	STRING	none	none	none	empty string
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
MODULENAME	STRING	none	none	none	empty string	Description not available.
NTH_ROW_NUMBER	NUMBER	none	none	none	0	The "n" number for the nth row selection.
OBJECT_LOC_NAME	STRING	none	none	none	empty string
OBJECT_LOC_UOID	STRING	none	none	none	empty string
OBJECT_TYPE	STRING	none	none	none	empty string
OBJECT_UOID	STRING	none	none	none	empty string
ORDER_RESULT_SET_BY	STRING	none	none	none	empty string	A list of lookup table columns with which to sort result rows before selecting the single row result.
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
PARENT_OBJECT_LOC_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_LOC_UOID	STRING	none	none	none	empty string
PARENT_OBJECT_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_TYPE	STRING	none	none	none	empty string
PARENT_OBJECT_UOID	STRING	none	none	none	empty string
PARENT_OPERATOR_NAME	STRING	none	none	none	empty string
PARENT_OPERATOR_UOID	STRING	none	none	none	empty string
RECORD_TYPE_VALUES	STRING	none	none	none	empty string	Record Type Values.
RETURN_TABLE_OF_SCALAR	BOOLEAN	true, false	none	none	false	This property specifies whether the return of the table function is a TABLE of SCALAR or not.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
ROW_LOCATOR	STRING	none	none	none	empty string	An expression indicating which attribute within the input group is the row locator.
ROW_LOCATOR_VALUES	STRING	none	none	none	NULL, NULL	A comma-separated expressions that gives the possible values of the row locator within a unpivot group.
ROW_POSITION	STRING	ALL_ROWS, ANY_ROW, ERROR, FIRST_ROW, LAST_ROW, NTH_ROW	none	none	ANY_ROW	Specifies which row from result set is to be selected as the single row lookup result.
SCHEMA	STRING(30)	none	none	none	empty string	Schema
SLOWLY_CHANGING_TYPE	STRING	TYPE1, TYPE2, TYPE3	none	none	TYPE2	The slowly changing type of this target.
SPLIT_CONDITION	STRING	none	none	none	empty string	Condition that defines when to perform the attribute maps for the attributes in this group.
TABLENAME	STRING	none	none	none	empty string	The source table corresponding to the LCR
TARGET_TABLE_NAME	STRING(32)	none	none	none	empty string	The table name bound to this target.
TARGET_TABLE_UOID	STRING	none	none	none	empty string
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
TYPE2_HISTORY_LOOKUP_DATE	STRING	none	none	none	SYSDATE	A date expression used when doing a lookup on a type 2 dimension level, to specify the historical date for which to retrieve data. If blank, the most current record is used.

ATTRIBUTE Object

Table 8-9 ATTRIBUTE Object

Property	Type	Choices	Min	Max	Default	Description
ADDRESS_TYPE	STRING	NA_ADDRTYPE_DUAL, NA_ADDRTYPE_NORMAL	none	none	NA_ADDRTYPE_NORMAL	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.
AGGMAP_NAME	STRING	none	none	none	empty string
ATTRIBUTE_ROLE	STRING	END_DATE, LOOKUP_ACTIVE_DATE, MEASURE, NATURAL_KEY, NATURAL_KEY_AND_SURROGATE_KEY, NONE, PARENT_NATURAL_KEY, PARENT_NATURAL_KEY_AND_PARENT_SURROGATE_KEY, PARENT_REF_KEY, PARENT_SURROGATE_KEY, PREV_VALUE, START_DATE, SURROGATE_KEY, TRIGGER	none	none	NONE	The type of role to indicate how this attribute will be used in history logging. History As Previous Value indicates that this attribute will be used to keep previous value. Surrogate Identifier indicates that this attribute will be used to keep the surrogate identifier. Natural Identifier indicates that this attribute will be used to keep the natural identifier. Effective Time indicates that this attribute will be used as the effective time of the version. Expiration Time indicates that this attribute will be used as the expiration time of the version. Trigger indicates that this attribute will be used to trigger history logging. If none is specified, this attribute will be used to keep current value.
ATTR_NOT_NULL	BOOLEAN	true, false	none	none	false
BINDING_COLUMN_NAME	STRING	none	none	none	empty string	The binding column name for this attribute
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
CODE_TEMPLATE_SCD	STRING(9)	SCD_END, SCD_FLAG, SCD_INS, SCD_NK, SCD_SK, SCD_START, SCD_UND, SCD_UPD	none	none	SCD_UND	Slowly changing dimension behavior for this attribute.
CODE_TEMPLATE_UPDATE	STRING(3)	NO, YES	none	none	YES	A boolean value indicating whether this attribute will included in code template functions using the UPD (Update) tag.
CODE_TEMPLATE_USER_DEFINED_1	STRING(3)	NO, YES	none	none	NO	A boolean value indicating whether this attribute will included in code template functions using the UD1 (User Defined 1) tag.
CODE_TEMPLATE_USER_DEFINED_2	STRING(3)	NO, YES	none	none	NO	A boolean value indicating whether this attribute will included in code template functions using the UD2 (User Defined 2) tag.
CODE_TEMPLATE_USER_DEFINED_3	STRING(3)	NO, YES	none	none	NO	A boolean value indicating whether this attribute will included in code template functions using the UD3 (User Defined 3) tag.
CODE_TEMPLATE_USER_DEFINED_4	STRING(3)	NO, YES	none	none	NO	A boolean value indicating whether this attribute will included in code template functions using the UD4 (User Defined 4) tag.
CODE_TEMPLATE_USER_DEFINED_5	STRING(3)	NO, YES	none	none	NO	A boolean value indicating whether this attribute will included in code template functions using the UD5 (User Defined 5) tag.
COLUMN_USAGE	STRING	CDC_COL, ROWID, ROWNUM, TABLE_COL	none	none	TABLE_COL
CONTROL_FLOW	BOOLEAN	true, false	none	none	false
CONTROL_STATIC	BOOLEAN	true, false	none	none	false
DATA_TYPE	STRING	none	none	none	empty string	The data type of the attribute
DEFAULT_VALUE	STRING	none	none	none	empty string	The default value for the attribute, used for orphan management default parent record creation.
DIMENSION_ATTRIBUTE_NAME	STRING	none	none	none	empty string	The dimension attribute referenced to by this level attribute.
EXPRESSION	STRING	none	none	none	empty string	The output expression for the attribute
FIELD_DATA_TYPE	STRING	BYTEINT, CHAR, DATE, DECIMAL, DECIMAL EXTERNAL, DOUBLE, FLOAT, FLOAT EXTERNAL, GRAPHIC, GRAPHIC EXTERNAL, INTEGER, INTEGER EXTERNAL, INTEGER UNSIGNED, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, LONG VARRAW, RAW, SMALLINT, SMALLINT UNSIGNED, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARCHAR, VARCHARC, VARGRAPHIC, VARRAW, VARRAWC, ZONED, ZONED EXTERNAL	none	none	CHAR	SQL Data Type of the field in the file to which this operator is bound.
FIELD_DATA_TYPE_LENGTH	NUMBER	none	none	none	0	Field Length of the field in the file to which this operator is bound.
FIELD_DATA_TYPE_PRECISION	NUMBER	none	none	none	0	Field Precision of the field in the file to which this operator is bound.
FIELD_DATA_TYPE_SCALE	NUMBER	none	none	none	0	Field Scale of the field in the file to which this operator is bound.
FIELD_DEFAULTIF_VALUE	STRING	none	none	none	empty string	The expression that indicates the value of the field is blank or zero, based on the datatype.
FIELD_END_POSITION	NUMBER	none	none	none	0	The ending position of the field in the file
FIELD_MASK	STRING	none	none	none	empty string	The mask for the field
FIELD_NULLIF_VALUE	STRING	none	none	none	empty string	The expression that indicates the value of the field is null
FIELD_START_POSITION	NUMBER	none	none	none	0	The starting position of the field in the file
FRACTIONAL_SECONDS_PRECISION	NUMBER	none	none	none	0	The data fractional seconds precision value of the attribute
FUNCTION_RETURN	BOOLEAN	true, false	none	none	false	Specifies whether this output is the return value of this function
GROUP_KEY	BOOLEAN	true, false	none	none	false	A boolean value to indicate whether this input attribute is a part of the unpivot group key.
HISTORY_ATTRIBUTE	STRING	none	none	none	empty string	The bound name of the attribute to indicate where the history of the current attribute is to be logged.
INPUT_ROLE	STRING	NA_ADDRESS, NA_ADDRESS2, NA_CITY, NA_COUNTRYCODE, NA_COUNTRYNAME, NA_FIRMNAME, NA_FIRSTNAME, NA_FIRSTPARTNAME, NA_LASTLINE, NA_LASTLINE_2, NA_LASTNAME, NA_LASTPARTNAME, NA_LINE1, NA_LINE10, NA_LINE2, NA_LINE3, NA_LINE4, NA_LINE5, NA_LINE6, NA_LINE7, NA_LINE8, NA_LINE9, NA_LOCALITYNAME, NA_LOCALITY_2, NA_LOCALITY_3, NA_LOCALITY_4, NA_MIDDLENAME, NA_MIDDLENAME2, NA_MIDDLENAME3, NA_NEIGHBORHOOD, NA_NONE, NA_PASSTHRU, NA_PERSON, NA_PERSON2, NA_PERSON3, NA_POSTALCODE, NA_POSTNAME, NA_PRENAME, NA_PRIMARYADDRESS, NA_SECONDARYADDRESS, NA_STATE	none	none	NA_NONE	Assigns a name-address input role to the selected input attribute
INSTANCE	STRING	NA_INSTANCE_FIFTH, NA_INSTANCE_FIRST, NA_INSTANCE_FOURTH, NA_INSTANCE_SECOND, NA_INSTANCE_SIXTH, NA_INSTANCE_THIRD	none	none	NA_INSTANCE_FIRST	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.
IN_MATCHING_ATTRIBUTE	STRING	none	none	none	empty string	Defines the matching output attribute for the "IN" subquery
IS_AGGREGATION	STRING	NO, YES	none	none	NO
IS_CAST_TARGET	BOOLEAN	true, false	none	none	false	Description not available.
IS_CHUNKING_COLUMN	BOOLEAN	true, false	none	none	false	This Number Column will be used as the chunking column .
IS_OPTIONAL	BOOLEAN	true, false	none	none	false	If true, the input is not required to be connected
IS_PREDEFINED_CONSTANT	BOOLEAN	true, false	none	none	false	Description not available.
IS_VARIABLE_EXPRESSION	BOOLEAN	true, false	none	none	false	If true, the expression value is stored as a runtime variable. The value is altered only when the write condition is true.
JOIN_INPUT_UOID	STRING	none	none	none	empty string
JOIN_OUTPUT_UOID	STRING	none	none	none	empty string
LENGTH	NUMBER	none	none	none	0
LEVEL_ATTRIBUTE_COLNAME_NAME	STRING	none	none	none	empty string	Column name in the AW staging table and source view for this attribute.
LEVEL_ATTRIBUTE_ISPARENT	STRING	NO, YES	none	none	NO	Indicates whether this is a parent level.
LEVEL_ATTRIBUTE_LEVEL_INDICATOR_COLNAME	STRING	none	none	none	empty string	Level indicating columns name. This level will contain the name of the name of the level this parent reference belongs to. This is relavant only for skip level hierarchies.
LEVEL_ATTRIBUTE_NAME	STRING	none	none	none	empty string	The name of the Level Attribute.
LEVEL_ATTRIBUTE_OBJECT_ID	STRING	none	none	none	empty string
LEVEL_PARENTHIERARCHY	STRING	none	none	none	empty string	Name of the parent hierarchy.
LEVEL_PARENTREF_PARENTLEVEL	STRING	none	none	none	empty string	The name of the parent level if relavant.
LEVEL_RELATIONSHIP_NAME	STRING	none	none	none	empty string	The level relationship name associated to this attribute.
LOADING_FLAG	STRING	none	none	none	YES	A boolean value to indicate whether this attribute will particiate in the load operation.
LOAD_COLUMN_WHEN_INSERTING_ROW	STRING(3)	NO, YES	none	none	YES	A boolean value to indicate whether this attribute will particiate in the insert load operation.
LOAD_COLUMN_WHEN_UPDATING_ROW	STRING(3)	NO, YES	none	none	YES	A boolean value to indicate whether this attribute will particiate in the update load operation.
LOAD_MATCHING	STRING	NO, YES	none	none	NO	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 load operation.
LOAD_ON_INSERT	STRING(3)	NO, YES	none	none	YES	A boolean value to indicate whether this level attribute will participate in an insert when inserting a new record. Has no effect for SCD type 2 trigger or business key attributes.
LOAD_ON_UPDATE	STRING(3)	NO, YES	none	none	YES	A boolean value to indicate whether this level attribute will participate in an update when updating an existing record. Has no effect for SCD type 2 trigger attributes.
LOOKUP_ATTRIBUTE_ROLE	STRING	DIMENSION_KEY, END_DATE, NATURAL_KEY, NATURAL_KEY_AND_SURROGATE_KEY, NONE, PREV_VALUE, START_DATE, SURROGATE_KEY, TRIGGER	none	none	NONE	The role of the attribute, synchronized from the referencing lookup table or level
LOOKUP_MATCHING	STRING	NO, YES	none	none	NO	A boolean value to indicate whether this attribute will be used to construct the lookup condition to resolve level reference between the incoming child data and the existing parent data on the target during the selected operation.
MATCHING_ROW	NUMBER	none	1	1000	1	An positive integer to indicate from which row within the unpivot group this output attribute obtains its data.
MATCH_COLUMN_WHEN_DELETING_ROW	STRING(3)	NO, YES	none	none	NO	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.
MATCH_COLUMN_WHEN_UPDATING_ROW	STRING(3)	NO, YES	none	none	NO	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.
MCM_MATCH_VALUE	STRING	none	none	none	empty string
MERGE_ATTR	STRING	none	none	none	empty string	Related merge attribute
NULL_VALUE	STRING	none	none	none	NULL	The data value that is interpreted as "null" by orphan management. Default is SQL NULL, specified as unquoted NULL.
OUTPUT_COMPONENT	STRING	NA_ADDRESS, NA_ADDRESS2, NA_ADDRESSCORRECTED, NA_ADDRESSTYPE, NA_AUTO_ZONE_IND, NA_BOXNAME, NA_BOXNUMBER, NA_BUILDINGNAME, NA_CART, NA_CBSA_CODE, NA_CBSA_DESC, NA_CENSUSID, NA_CHECKDIGIT, NA_CITY, NA_CITYCORRECTED, NA_CITYMATCH, NA_CITYWARNING, NA_CITY_ABBREV, NA_CITY_ABBREV_2, NA_CITY_ALTERNATE, NA_COMPLEX, NA_COUNTRYCODE, NA_COUNTRYCODE3, NA_COUNTRYNAME, NA_COUNTYNAME, NA_DELIVERYBEATCODE, NA_DELIVERYOFFICECODE, NA_DELIVERYPOINT, NA_EMAIL, NA_EXTRA_1, NA_EXTRA_10, NA_EXTRA_11, NA_EXTRA_12, NA_EXTRA_13, NA_EXTRA_14, NA_EXTRA_15, NA_EXTRA_16, NA_EXTRA_17, NA_EXTRA_18, NA_EXTRA_19, NA_EXTRA_2, NA_EXTRA_20, NA_EXTRA_3, NA_EXTRA_4, NA_EXTRA_5, NA_EXTRA_6, NA_EXTRA_7, NA_EXTRA_8, NA_EXTRA_9, NA_FIPS, NA_FIPSCOUNTY, NA_FIPS_PLACE_CODE, NA_FIRMCOUNT, NA_FIRMNAME, NA_FIRM_LOC, NA_FIRSTNAME, NA_FIRSTNAMESTD, NA_GENDER, NA_GEO_MATCH_PREC, NA_INSTALLATIONNAME, NA_INSTALLATIONTYPE, NA_ISADDRESSVERIFIABLE, NA_ISFOUND, NA_ISGOODADDRESS, NA_ISGOODGROUP, NA_ISGOODNAME, NA_ISPARSED, NA_LACS, NA_LASTLINE, NA_LASTLINE_2, NA_LASTNAME, NA_LATITUDE, NA_LOCALITYCODE, NA_LOCALITYNAME, NA_LOCALITY_2, NA_LOCALITY_3, NA_LOCALITY_4, NA_LONGITUDE, NA_LOT, NA_LOT_ORDER, NA_MCD, NA_MIDDLENAME, NA_MIDDLENAME2, NA_MIDDLENAME2STD, NA_MIDDLENAME3, NA_MIDDLENAME3STD, NA_MIDDLENAMESTD, NA_MISCADDRESS, NA_MSA, NA_NAMEDESIGNATOR, NA_NAMEWARNING, NA_NAME_FIRM_EXTRA, NA_NEIGHBORHOOD, NA_NONAMBIGUOUSMATCH, NA_NONE, NA_NP_SEC_ADDR, NA_NP_UNIT_DESIG, NA_NP_UNIT_NBR, NA_OTHERPOSTNAME, NA_PARSESTATUS, NA_PARSESTATUSDESC, NA_PARSINGCOUNTRY, NA_PASSTHRU, NA_PERSON, NA_PERSONCOUNT, NA_PHONE, NA_POSTALCODE, NA_POSTALCODECORRECTED, NA_POSTALCODEFORMATTED, NA_POSTDIRECTIONAL, NA_POSTNAME, NA_PREDIRECTIONAL, NA_PRENAME, NA_PRIMARYADDRESS, NA_PRIM_NAME_2, NA_RELATIONSHIP, NA_ROUTENAME, NA_ROUTENUMBER, NA_SECONDARYADDRESS, NA_SSN, NA_STATE, NA_STREETCOMPCORRECTED, NA_STREETCOMPMATCH, NA_STREETCORRECTED, NA_STREETNAME, NA_STREETNAMEMATCH, NA_STREETNUMBER, NA_STREETNUMBERMATCH, NA_STREETTYPE, NA_STREETWARNING, NA_TITLE, NA_UNITDESIGNATOR, NA_UNITNUMBER, NA_URBANIZATIONNAME, NA_URBAN_IND, NA_ZIP4, NA_ZIP5	none	none	NA_NONE	Assigns a Name and Address output component to the selected output attribute.
OUTPUT_GROUP_KEY	BOOLEAN	true, false	none	none	false	A boolean value to indicate whether this output attribute is a part of the unpivot group key, which obtains its value from its corresponding input attribute.
PIVOT_EXPRESSION	STRING	none	none	none	empty string	A comma-separated expression that gives the input attribute to be used for each output row in the pivot group.
PRECISION	NUMBER	none	none	none	0	The data precision value of the attribute
REFERENCED_LEVEL_ATTRIBUTE_NAME	STRING	none	none	none	empty string	The bound name of the parent level attribute associated to this attribute.
REFERENCED_LEVEL_NAME	STRING	none	none	none	empty string	The bound name of the parent level group associated to this attribute.
REFERENCING_TYPE	STRING	LOOKUP_KEY, LOOKUP_KEY_AND_REFERENCE_KEY_ALL, LOOKUP_KEY_AND_REFERENCE_KEY_ONLY, NONE, REFERENCE_KEY_ALL, REFERENCE_KEY_ONLY	none	none	NONE	The type of reference to indicate how this attribute participates in resolving existing level relationships and level implementations. If Lookup Reference Attribute is specified, this attribute will be used as lookup attribute upon parent level to resolve level implementations during loading. If Level Relationship Attribute (Snowflake) is specified, this attribute will be directly used as level relationship attribute and no lookup upon parent level would be performed during loading. If Level Relationship Attribute (Star) is specified, this attribute will be directly used as level relationship attribute, as well as lookup attribute upon parent level to resolve level implementations during loading. If none is specified, this attribute does not participate in any level relationship.
REMOVE_MATCHING	STRING	NO, YES	none	none	NO	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 remove operation.
REPRESENTS_LOOKUP_TABLE_COLUMN	BOOLEAN	true, false	none	none	false
SCALE	NUMBER	none	none	none	0	The data scale value of the attribute
SKIP_LEVEL_DIMENSION	STRING	NO, YES	none	none	NO	Indicates whether this level has a skip level parent.
SOURCE_AGGREGATION_FUNCTION	STRING	none	none	none	SUM	The source loading aggregation function for the measure.
SUBQUERY_OUTPUT_MATCHING	STRING	none	none	none	empty string	A unique matching value which will match a corresponding property for an output attribute
TYPE_ATTRIBUTE_NAME	STRING	none	none	none	empty string	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.
TYPE_TWO_SCD_TRIGGER	STRING	NO, YES	none	none	NO	If YES, indicates that this attribute will be used as a trigger for type 2 Slowly Changing Dimension history recording.
UNPIVOT_EXPRESSION	STRING	none	none	none	NULL	An expression that gives the input attribute to be used as the output of this attribute.
UPDATE_OPERATION	STRING(3)	*=, +=, -=, /=, =, =-, =/, =\|\|, \|\|=	none	none	=	The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation. Only applicable to measure attributes.
VALUETYPE	STRING	NEW, NEW_OLD, OLD	none	none	NEW_OLD	Specifies the value type of this attribute
VARIABLE_INITIAL_VALUE	STRING	none	none	none	empty string	If this is a variable expression, then this is the initial value of the variable expression.
VARIABLE_WRITE_CONDITION	STRING	none	none	none	empty string	If this is a variable expression, then the variable value is set when processing a row where this condition is true.

AGGREGATOR_OPERATOR Object

Table 8-10 AGGREGATOR_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
GROUP_BY_CLAUSE	STRING	none	none	none	empty string	The Group By clause for the aggregation
HAVING_CLAUSE	STRING	none	none	none	empty string	The Having clause for the aggregation
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

ANYDATA_CAST_OPERATOR Object

Table 8-11 ANYDATA_CAST_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

CONSTANT_OPERATOR Object

Table 8-12 CONSTANT_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

CONSTRUCT_OBJECT_OPERATOR Object

Table 8-13 CONSTRUCT_OBJECT_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

CUBE_OPERATOR Object

Table 8-14 CUBE_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
ALLOW_PARALLEL_SOLVE	BOOLEAN	true, false	none	none	false	If true, allow parallel solve when solving the cube.
AUTOMATIC_HINTS_ENABLED	BOOLEAN	true, false	none	none	true	Automatic hints enabled using SQL
AW_LOAD_STAGETABLE_NAME	STRING	none	none	none	empty string	The stage table used to load the AW level
AW_LOAD_VIEW_NAME	STRING	none	none	none	empty string	The view used to load the AW level
AW_STAGED_LOAD	BOOLEAN	true, false	none	none	false	If true, the set-based AW load data is staged into a temporary table before loading into the AW.
BOUND_NAME	STRING	none	none	none	empty string	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_STORAGE_ISAW	STRING	NO, YES	none	none	NO	Indicates whether the storage for this cube in AW.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
DIMENSION_AWNAME	STRING	none	none	none	empty string	AW Name which contains this Dimension.
DML_ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target for DML error logging.
ENABLE_SOURCE_AGGREGATION	BOOLEAN	true, false	none	none	false	If set, add source loading aggregation grouped by the dimension reference attributes. Measure aggregation functions are determined by the SOURCE_AGGREGATION_FUNCTION attribute properties, or the presence of "MAX", "MIN", "SUM", "AVG" or "MEDIAN" in the cube attribute name.
ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target to log invalid records.
EXTRACTION_HINT	STRING	none	none	none	empty string	Hint used when extracting from this table using SQL
HEIGHT	NUMBER	none	none	none	150
INCREMENTAL_AGGREGATION	BOOLEAN	true, false	none	none	true	Indicates whether incremental aggregation should be done or full aggregation.
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
LOADING_HINT	STRING	none	none	none	empty string	Hint used when loading into this table using SQL
LOADING_TYPE	STRING	INSERT_LOAD, LOAD, REMOVE	none	none	LOAD	The loading operation to be performed when this is a target. If INSERT_LOAD is specified (recommended if orphan management is enabled), OWB will try to insert all input data into the target. If LOAD is specified, OWB will try to merge all input data into the target. If REMOVE is specified, OWB will try to match between the input data and target data to compute existing data; it will then remove existing data from target.
LOAD_POLICY_FOR_INVALID_KEY	STRING	DEFAULT_DIMENSION_RECORD, NO_MAINTENANCE, REJECT_ORPHAN	none	none	NO_MAINTENANCE	The orphan management policy for loading records which contain an invalid dimension natural key reference.
LOAD_POLICY_FOR_NULL_KEY	STRING	DEFAULT_DIMENSION_RECORD, NO_MAINTENANCE, REJECT_ORPHAN	none	none	NO_MAINTENANCE	The orphan management policy for loading records which contain a null dimension natural key reference.
MATCHING_CRITERIA	STRING	MATCH_BY_ATTRIBUTES, MATCH_BY_NATURAL_ID	none	none	MATCH_BY_NATURAL_ID	The type of matching criteria between the incoming data and the existing data on the target during the selected operation. If Matching by Attributes is selected, then the matching attributes (specified in the attribute property) will be matched to perform the selected operation. If Matching by Natural Identifier is selected, then the natural identifier attributes will be matched to perform the selected operation.
MAX_JOB_QUEUES_ALLOCATED	NUMBER	none	1	1000	0	The maximum number of job queues allocated when solving the cube.
OBJECT_LOC_NAME	STRING	none	none	none	empty string
OBJECT_LOC_UOID	STRING	none	none	none	empty string
OBJECT_TYPE	STRING	none	none	none	empty string
OBJECT_UOID	STRING	none	none	none	empty string
ORPHAN_POLICY_OF_REMOVE	STRING	NO_MAINTENANCE	none	none	NO_MAINTENANCE	The policy for invalid level records of REMOVE that is referenced by one or more existing child level records. If No Maintenance is specified, all input level records will be removed from target. If Reject Remove is specified, invalid level records will not be removed from target, but rather reported as errors and redirected into error target. If Cascade Remove is specified, all input level records records will be removed from target in a cascading fashion.
PARENT_OBJECT_LOC_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_LOC_UOID	STRING	none	none	none	empty string
PARENT_OBJECT_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_TYPE	STRING	none	none	none	empty string
PARENT_OBJECT_UOID	STRING	none	none	none	empty string
PARENT_OPERATOR_NAME	STRING	none	none	none	empty string
PARENT_OPERATOR_UOID	STRING	none	none	none	empty string
RECORD_ERROR_ROWS	STRING	NO, YES	none	none	YES	If true, orphan error rows that are encountered in the source rowset will be recorded in the error table.
RUN_AGGREGATION	STRING	NO, YES	none	none	YES	A boolean value to indicate whether to solve the cube or not . Specify YES and cube data will be precomputed for the levels specified in the definition of cube
SLOWLY_CHANGING_TYPE	STRING	TYPE1	none	none	TYPE1	The slowly changing type of this target.
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
TRUNCATE_ERROR_TABLE	STRING(3)	NO, YES	none	none	NO	If YES, then the error table will be truncated prior to use. This is ignored if there are no active data rules applied to the object.
TRUNCATE_LOAD	BOOLEAN	true, false	none	none	false	The truncate flag to indicate whether all existing dimension values should be truncated before load begins (AW only).
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

DATA_GENERATOR_OPERATOR Object

Table 8-15 DATA_GENERATOR_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

DEDUPLICATOR_OPERATOR Object

Table 8-16 DEDUPLICATOR_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

DIMENSION_OPERATOR Object

Table 8-17 DIMENSION_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
AUTOMATIC_HINTS_ENABLED	BOOLEAN	true, false	none	none	true	Automatic hints enabled using SQL
AW_LOAD_MODEL	STRING	OTHER, SNOWFLAKE, STAR	none	none	SNOWFLAKE	The loading model for the AW dimension - star, snowflake, or other.
AW_STAGED_LOAD	BOOLEAN	true, false	none	none	false	If true, the set-based AW load data is staged into a temporary table before loading into the AW.
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
CREATE_DEFAULT_RECORDS	STRING	NO, YES	none	none	NO	If true, default records are created for each level, for cube orphan management. If "default parent" orphan management policy is set, the records will be created regardless of this setting.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
DEFAULT_EFFECTIVE_TIME_OF_INITIAL_RECORD	STRING	none	none	none	SYSDATE	A date value to be served as the effective time of the initial record.
DEFAULT_EFFECTIVE_TIME_OF_OPEN_RECORD	STRING	none	none	none	SYSDATE	A date value to be served as the effective time of a newly created open record. The same date value is also served as the expiration time to close an existing open record.
DEFAULT_EXPIRATION_TIME_OF_OPEN_RECORD	STRING	none	none	none	NULL	A date value to be served as the expiration time of a newly created open record.
DIMENSION_ATTRIBUTES	STRING	none	none	none	empty string	Contains list of all Dimension Attributes.
DIMENSION_AWNAME	STRING	none	none	none	empty string	AW Name which contains this Dimension.
DIMENSION_ISAW	STRING(3)	NO, YES	none	none	YES	Flag to indicate whether storage is AW.
DML_ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target for DML error logging.
ENABLE_SOURCE_DEDUP	BOOLEAN	true, false	none	none	true	If set, add source business key deduplication using an aggregator operator when loading the dimension, with some extra performance cost. Not applicable if SUPPORT_MULTIPLE_TYPE2_HISTORY_RECORDS is set to true for type 2 dimension.
ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target to log invalid records.
EXTRACTION_HINT	STRING	none	none	none	empty string	Hint used when extracting from this table using SQL
HEIGHT	NUMBER	none	none	none	150
HIERARCHY_LEVEL_LIST	STRING	none	none	none	empty string	Contains list of all Dimension Attributes.
HISTORY_LOGGING	STRING	NO, YES	none	none	YES	A boolean value to indicate whether history logging will be activated. Specify NO and the loading operation will be rollback to type 1 such that all values will be overwritten directly without logging any history.
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
LEVEL_LIST	STRING	none	none	none	empty string	Contains list of all Level Attributes.
LOADING_HINT	STRING	none	none	none	empty string	Hint used when loading into this table using SQL
LOADING_TYPE	STRING	LOAD, REMOVE	none	none	LOAD	The loading operation to be performed when this is a target. If LOAD is specified, OWB will try to match between the input data and target data to compute new data and existing data; it will then create new data, as well as modify existing data onto target. If REMOVE is specified, OWB will try to match between the input data and target data to compute existing data; it will then remove existing data from target.
LOAD_POLICY_FOR_INVALID_KEY	STRING	DEFAULT_PARENT, NO_MAINTENANCE, REJECT_ORPHAN	none	none	NO_MAINTENANCE	The orphan management policy for loading level records which contain an invalid (unfound) parent natural key reference.
LOAD_POLICY_FOR_NULL_KEY	STRING	DEFAULT_PARENT, NO_MAINTENANCE, REJECT_ORPHAN	none	none	NO_MAINTENANCE	The orphan management policy for loading level records which contain a null parent natural key reference.
MATCHING_CRITERIA	STRING	MATCH_BY_ATTRIBUTES, MATCH_BY_NATURAL_ID	none	none	MATCH_BY_NATURAL_ID	The type of matching criteria between the incoming data and the existing data on the target during the selected operation. If Matching by Attributes is selected, then the matching attributes (specified in the attribute property) will be matched to perform the selected operation. If Matching by Natural Identifier is selected, then the natural identifier attributes will be matched to perform the selected operation.
OBJECT_LOC_NAME	STRING	none	none	none	empty string
OBJECT_LOC_UOID	STRING	none	none	none	empty string
OBJECT_TYPE	STRING	none	none	none	empty string
OBJECT_UOID	STRING	none	none	none	empty string
ORPHAN_POLICY_OF_REMOVE	STRING	NO_MAINTENANCE, REJECT_REMOVAL	none	none	NO_MAINTENANCE	The orphan management policy for removing parent level records.
PARENT_OBJECT_LOC_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_LOC_UOID	STRING	none	none	none	empty string
PARENT_OBJECT_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_TYPE	STRING	none	none	none	empty string
PARENT_OBJECT_UOID	STRING	none	none	none	empty string
PARENT_OPERATOR_NAME	STRING	none	none	none	empty string
PARENT_OPERATOR_UOID	STRING	none	none	none	empty string
RECORD_ERROR_ROWS	STRING	NO, YES	none	none	YES	If true, orphan error rows that are encountered in the source rowset will be recorded in the error table.
SLOWLY_CHANGING_TYPE	STRING	TYPE1, TYPE2, TYPE3	none	none	TYPE2	The slowly changing type of this target.
SUPPORT_MULTIPLE_TYPE2_HISTORY_RECORDS	BOOLEAN	true, false	none	none	false	If true, then multiple history rows can be created for the same business id in a single load execution.
SUPPORT_OUT_OF_ORDER_HISTORY_LOADING	BOOLEAN	true, false	none	none	false	If true, loading of out of order changes to the dimension history in consecutive loads is supported. This may have a performance cost.
SURROGATE_IDENTIFIER_LOADING_POLICY	STRING	none	none	none	empty string	The name of the sequence used to generate surrogate key values when loading the dimension.
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
TRUNCATE_ERROR_TABLE	STRING(3)	NO, YES	none	none	NO	If YES, then the error table target(s) will be truncated prior to use. This applies to the logical orphan management error tables, but not the DML error tables (if defined).
TRUNCATE_LOAD	BOOLEAN	true, false	none	none	false	The truncate flag to indicate whether all existing dimension values should be truncated before load begins (AW only).
TYPE2_MATCH_CURRENT_ONLY	STRING	NO, YES	none	none	YES	If set to YES, only the current record will be used when performing the selected operation (remove or extract) for type 2 dimension.
TYPE2_RECORD_GAP_INTERVAL	NUMBER	none	none	none	1	A numeric value indicating the number of units (see TYPE2_RECORD_GAP_INTERVAL_UNITS property below) that will be added to the expiration date of the previous closed record, to create the effective date of a new open record.
TYPE2_RECORD_GAP_INTERVAL_UNITS	STRING	DAYS, HOURS, MINUTES, SECONDS, WEEKS	none	none	SECONDS	A value indicating the units used for the gap that will be added to the expiration date of the previous closed record, to create the effective date of a new open record.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

EXPAND_OBJECT_OPERATOR Object

Table 8-18 EXPAND_OBJECT_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

EXPRESSION_OPERATOR Object

Table 8-19 EXPRESSION_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

EXTERNAL_TABLE_OPERATOR Object

Table 8-20 EXTERNAL_TABLE_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
ADVANCED_MATCH_BY_CONSTRAINT	STRING	none	none	none	NO_CONSTRAINTS	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.
AUTOMATIC_HINTS_ENABLED	BOOLEAN	true, false	none	none	true	Automatic hints enabled using SQL
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
CHUNK_FILTER_CONDITION	STRING	none	none	none	get_chunk_iterator = 1	The filter condition used to determine the set of rows that gets processed for a specified chunk. The condition should use variable name get_chunk_iterator, which starts at one and is incremented for each chunk.
DATABASE_FILE_NAME	STRING	none	none	none	empty string	Database file name to allocate extents from
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DATA_COLLECTION_FREQUENCY	STRING(16)	DAY, HOUR, MINUTE, MONTH, QUARTER, UNKNOWN, YEAR	none	none	UNKNOWN	New Data Granularity
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LINK	STRING(128)	none	none	none	empty string	DB Link name used to bind to a physical entity during a debug session
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_SCHEMA	STRING(30)	none	none	none	empty string	Schema name used to bind to a physical entity during a debug session
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
DIRECT	BOOLEAN	true, false	none	none	false
DML_ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target for DML error logging.
ENABLE_CONSTRAINTS	BOOLEAN	true, false	none	none	true	Enable Constraints
ERROR_SELECT_FILTER	STRING(3)	NO, YES	none	none	YES	Rows selected from the error table will contain only errors created by this operator in this map execution
ERROR_SELECT_ROLL_UP	STRING(3)	NO, YES	none	none	YES	'Records selected from the error table will be rolled up by the error name, so all errors generated by a particular input record will be rolled up into a single record with the error names concatenated in the error name attribute.
ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target to log invalid records.
EVALUATE_CHECK_CONSTRAINTS	BOOLEAN	true, false	none	none	false	Evaluate check constraints
EXCEPTIONS_TABLE_NAME	STRING	none	none	none	empty string	Exceptions Table Name
EXTRACTION_HINT	STRING	none	none	none	empty string	Hint used when extracting from this table using SQL
HEIGHT	NUMBER	none	none	none	150
IS_CHUNKING_ENABLED	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time.
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_NUMBER_COLUMN_CHUNKING	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time using the number column .
IS_TEMP_STAGE_TABLE	BOOLEAN	true, false	none	none	false	If set, specifies that this operator will be bound to a temporary staging table created at map deployment time. The referencing object will be ignored.
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
LOADING_HINT	STRING	none	none	none	empty string	Hint used when loading into this table using SQL
LOADING_TYPE	STRING	none	none	none	NONE	The loading operation to be performed when this is a target.
MATCH_BY_CONSTRAINT	STRING	none	none	none	ALL_CONSTRAINTS	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.
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OBJECT_LOC_NAME	STRING	none	none	none	empty string
OBJECT_LOC_UOID	STRING	none	none	none	empty string
OBJECT_TYPE	STRING	none	none	none	empty string
OBJECT_UOID	STRING	none	none	none	empty string
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
PARENT_OBJECT_LOC_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_LOC_UOID	STRING	none	none	none	empty string
PARENT_OBJECT_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_TYPE	STRING	none	none	none	empty string
PARENT_OBJECT_UOID	STRING	none	none	none	empty string
PARENT_OPERATOR_NAME	STRING	none	none	none	empty string
PARENT_OPERATOR_UOID	STRING	none	none	none	empty string
PARTITION_NAME	STRING	none	none	none	empty string	Partition Name
PEL_ENABLED	BOOLEAN	true, false	none	none	false	PEL Enabled
PRIMARY_SOURCE	STRING	NO, YES	none	none	NO	A boolean value to indicate whether this is a primary source or not (only used in EDW).
RECORDS_TO_SKIP	NUMBER	none	0	none	0	Number of records to skip
REPLACE_DATA	BOOLEAN	true, false	none	none	false	Replace existing data in target partition if there is any.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SAMPLE_RATE	NUMBER	none	none	none	100	The sampling rate used when selecting from this table
SAMPLE_SEED	NUMBER	none	none	none	1	The sampling seed value. The random number generator is based on this sampling seed.
SAP_TABLE_TYPE	STRING	none	none	none	empty string	SAP Table Type
SCHEMA	STRING(30)	none	none	none	empty string	Schema
SINGLEROW	BOOLEAN	true, false	none	none	false	Singlerow
SORTED_INDEXES_CLAUSE	STRING	none	none	none	empty string	Sorted Indexes Clause
SUBPARTITION_NAME	STRING	none	none	none	empty string	Subpartition Name
TARGET_FILTER_FOR_DELETE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
TARGET_FILTER_FOR_UPDATE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
TEMP_STAGE_TABLE_EXTRA_DDL_CLAUSES	STRING	none	none	none	empty string	Extra DDL clauses that will be added to the temp staging table creation DDL, after the column definitions. Example: "TABLESPACE my_tblspc"
TEMP_STAGE_TABLE_ID	STRING	none	none	none	empty string	A String ID which identifies the temp stage table within the map. It can be used to create multiple operator instances of the same temp stage table.
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
TRAILING_NULLCOLS	BOOLEAN	true, false	none	none	false	Trailing Nullcols
TRUNCATE_ERROR_TABLE	STRING(3)	NO, YES	none	none	NO	If YES, then the error table will be truncated prior to use. This is ignored if there are no active data rules applied to the object.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

FILTER_OPERATOR Object

Table 8-21 FILTER_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
FILTER_CONDITION	STRING	none	none	none	empty string	The boolean filtering condition that identifies what data is to be processed. Any row with a false condition will be ignored.
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

SUBQUERY_FILTER_OPERATOR Object

Table 8-22 SUBQUERY_FILTER_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
SUBQUERY_FILTER_CONDITION	STRING	none	none	none	empty string	The Filter Condition for the subquery operator, if blank then the subquery stands alone with no join to the top-level query.
SUBQUERY_INPUT_ROLE	STRING(16)	EXISTS, IN, NOT_EXISTS, NOT_IN	none	none	EXISTS	The role the input stream plays in the subquery filter condition.
SUBQUERY_JOIN_CONDITION_USER_MODIFIED_FLAG	BOOLEAN	true, false	none	none	false	The Join Condition has been modified by the user (do not generate default)
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

FLAT_FILE_OPERATOR Object

Table 8-23 FLAT_FILE_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by reconciliation for this item. Unlike other operators, it is not needed for generation. By default it is the same name as the item.
CONCATENATE_RECORDS	NUMBER	none	none	none	0	Number of Physical Records per Logical Record.
CONTINUATION_CHARACTER	STRING	none	none	none	empty string	Character that indicates the record is continued on the next line.
CONTINUATION_CHARACTER_ON_NEXT_LINE	BOOLEAN	true, false	none	none	FALSE	If there is a continuation character, is it at the start of the line.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_TARGET_DATA_FILE_LOCATION	STRING	none	none	none	empty string	The name of the directory in which to open the target data file. The directory must be deployed before the file can be created.
DEBUG_TARGET_DATA_FILE_NAME	STRING	none	none	none	empty string	Name of the target data file, including extension (file type). This name should not include the file path. To specify where the target data file will be created/appended, set the Target Data File Location.
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
ESCAPE_CHARACTER_FOR_ENCLOSURE	STRING	none	none	none	empty string	Escape character for data containing the enclosure character. This is only applicable with delimited files having enclosure characters.
FIELD_ENCLOSURE_CHARACTERS	STRING	none	none	none	empty string	Characters that wrap fields. Example ' or ".
FIELD_NAMES_IN_THE_FIRST_ROW	BOOLEAN	true, false	none	none	FALSE	Indicates whether file contains a header row.
FIELD_TERMINATION_CHARACTER	STRING	none	none	none	,	Character that separates the fields of a delimited file.
FILE_FORMAT	STRING	DELIMITED, FIXED	none	none	DELIMITED	File Format (Fixed or Delimited).
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
LOADING_TYPE	STRING(16)	INSERT, NONE, UPDATE	none	none	INSERT	The loading operation to be performed
NLS_CHARACTERSET	STRING	none	none	none	WE8MSWIN1252	NLS Characterset
OUTPUT_AS_XML	BOOLEAN	true, false	none	none	false	Output data to file in XML format.
RECORDS_TO_SKIP	NUMBER	none	0	none	0	Number of logical records to skip
RECORD_DELIMITER	STRING	none	none	none	empty string	Character that indicates the end of the record.
RECORD_SIZE	NUMBER	none	none	none	0	Size of a fixed length record.
RECORD_TYPE_LENGTH	NUMBER	none	none	none	0	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.
RECORD_TYPE_POSITION	NUMBER	none	none	none	0	If this is a multi record file, this will indicate the position of the field that identifies the type of record.
SAMPLED_FILE_NAME	STRING	none	none	none	empty string	The default name of the physical file to be used by sqlloader. If the file was sampled, the default was set from sampled file name.
SOURCE_DATA_FILE_LOCATION	STRING	none	none	none	empty string	The Location of the File Module of this Flat File at the time of reconciliation. Stored as UOID.
TARGET_DATA_FILE_LOCATION	STRING	none	none	none	empty string	The location used to access referenced entity.
TARGET_DATA_FILE_NAME	STRING	none	none	none	empty string	Name of the target data file, including extension (file type). This name should not include the file path. To specify where the target data file will be created/appended, set the Target Data File Location.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

INPUT_PARAMETER_OPERATOR Object

Table 8-24 INPUT_PARAMETER_OPERATOR Object

Property	Type	Choices	Min	Max	Default
BOUND_NAME	STRING	none	none	none	empty string
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

INPUT_SIGNATURE_OPERATOR Object

Table 8-25 INPUT_SIGNATURE_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

ITERATOR_OPERATOR Object

Table 8-26 ITERATOR_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

JOINER_OPERATOR Object

Table 8-27 JOINER_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
JOIN_CONDITION	STRING	none	none	none	empty string	The Join Condition for the join operator
JOIN_CONDITION_USER_MODIFIED_FLAG	BOOLEAN	true, false	none	none	false	The Join Condition has been modified by the user (do not generate default)
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

LOOKUP_OPERATOR Object

Table 8-28 LOOKUP_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

LCRCAST_OPERATOR Object

Table 8-29 LCRCAST_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

LCRSPLITTER_OPERATOR Object

Table 8-30 LCRSPLITTER_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

MATCHMERGE_OPERATOR Object

Table 8-31 MATCHMERGE_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
MATCH_KEYS	STRING	none	none	none	empty string	Ordered list of attributes that control the set of records to be matched at any at any particular time.
MATCH_NEW_RECORDS	BOOLEAN	true, false	none	none	false
MATCH_NEW_RECORD_CONDITION	STRING	none	none	none	empty string
MERGED_PREFIX	STRING	none	none	none	empty string	Set the prefix used for the merged attributes in the cross-reference group.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

MATERIALIZED_VIEW_OPERATOR Object

Table 8-32 MATERIALIZED_VIEW_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
ADVANCED_MATCH_BY_CONSTRAINT	STRING	none	none	none	NO_CONSTRAINTS	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.
AUTOMATIC_HINTS_ENABLED	BOOLEAN	true, false	none	none	true	Automatic hints enabled using SQL
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
CHUNK_FILTER_CONDITION	STRING	none	none	none	get_chunk_iterator = 1	The filter condition used to determine the set of rows that gets processed for a specified chunk. The condition should use variable name get_chunk_iterator, which starts at one and is incremented for each chunk.
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
DML_ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target for DML error logging.
ERROR_SELECT_FILTER	STRING(3)	NO, YES	none	none	YES	Rows selected from the error table will contain only errors created by this operator in this map execution
ERROR_SELECT_ROLL_UP	STRING(3)	NO, YES	none	none	YES	'Records selected from the error table will be rolled up by the error name, so all errors generated by a particular input record will be rolled up into a single record with the error names concatenated in the error name attribute.
ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target to log invalid records.
EXTRACTION_HINT	STRING	none	none	none	empty string	Hint used when extracting from this table using SQL
HEIGHT	NUMBER	none	none	none	150
IS_CHUNKING_ENABLED	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time.
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_NUMBER_COLUMN_CHUNKING	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time using the number column .
IS_TEMP_STAGE_TABLE	BOOLEAN	true, false	none	none	false	If set, specifies that this operator will be bound to a temporary staging table created at map deployment time. The referencing object will be ignored.
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
LOADING_HINT	STRING	none	none	none	empty string	Hint used when loading into this table using SQL
LOADING_TYPE	STRING(16)	CHECK_INSERT, DELETE, DELETE_INSERT, DERIVE_FROM_LCR, INSERT, INSERT_UPDATE, NONE, TRUNCATE_INSERT, UPDATE, UPDATE_INSERT	none	none	INSERT	The loading operation to be performed when this is a target.
MATCH_BY_CONSTRAINT	STRING	none	none	none	ALL_CONSTRAINTS	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.
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OBJECT_LOC_NAME	STRING	none	none	none	empty string
OBJECT_LOC_UOID	STRING	none	none	none	empty string
OBJECT_TYPE	STRING	none	none	none	empty string
OBJECT_UOID	STRING	none	none	none	empty string
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
PARENT_OBJECT_LOC_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_LOC_UOID	STRING	none	none	none	empty string
PARENT_OBJECT_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_TYPE	STRING	none	none	none	empty string
PARENT_OBJECT_UOID	STRING	none	none	none	empty string
PARENT_OPERATOR_NAME	STRING	none	none	none	empty string
PARENT_OPERATOR_UOID	STRING	none	none	none	empty string
PRIMARY_SOURCE	STRING	NO, YES	none	none	NO	A boolean value to indicate whether this is a primary source or not (only used in EDW).
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SAMPLE_RATE	NUMBER	none	none	none	100	The sampling rate used when selecting from this table
SAMPLE_SEED	NUMBER	none	none	none	1	The sampling seed value. The random number generator is based on this sampling seed.
SCHEMA	STRING(30)	none	none	none	empty string	Schema
TARGET_FILTER_FOR_DELETE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
TARGET_FILTER_FOR_UPDATE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
TEMP_STAGE_TABLE_EXTRA_DDL_CLAUSES	STRING	none	none	none	empty string	Extra DDL clauses that will be added to the temp staging table creation DDL, after the column definitions. Example: "TABLESPACE my_tblspc"
TEMP_STAGE_TABLE_ID	STRING	none	none	none	empty string	A String ID which identifies the temp stage table within the map. It can be used to create multiple operator instances of the same temp stage table.
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
TRUNCATE_ERROR_TABLE	STRING(3)	NO, YES	none	none	NO	If YES, then the error table will be truncated prior to use. This is ignored if there are no active data rules applied to the object.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

NAME_AND_ADDRESS_OPERATOR Object

Table 8-33 NAME_AND_ADDRESS_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
ADDRESS_LINE_1	STRING	none	none	none	empty string	Address line 1
ADDRESS_LINE_2	STRING	none	none	none	empty string	Address line 2
ADDRESS_LINE_3	STRING	none	none	none	empty string	Address line 3
ADDRESS_LINE_4	STRING	none	none	none	empty string	Address line 4
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
DUAL_ADDRESS_ASSIGNMENT	STRING	NA_DUALADDR_CLOSESTTOLASTLINE, NA_DUALADDR_POBOX, NA_DUALADDR_STREET	none	none	NA_DUALADDR_STREET	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.
GENERATE_CASS_REPORT	STRING	NA_NO, NA_YES	none	none	NA_NO	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.
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
LIST_NAME	STRING	none	none	none	empty string	The list name is optional and provides a reference for tracking multiple CASS reports.
PARSING_TYPE	STRING	NA_ADDRESSONLY, NA_NAMEANDADDRESS, NA_NAMEONLY	none	none	NA_NAMEANDADDRESS	Select a name-address parsing type to be performed on the input data
PRIMARY_COUNTRY	STRING	NA_AND, NA_ARE, NA_ARG, NA_AUS, NA_AUT, NA_BEL, NA_BGD, NA_BGR, NA_BHS, NA_BLZ, NA_BMU, NA_BRA, NA_BRB, NA_BRN, NA_CAN, NA_CHE, NA_CHL, NA_CHN, NA_COL, NA_CZE, NA_DEU, NA_DNK, NA_EGY, NA_ESP, NA_EST, NA_FIN, NA_FRA, NA_GBR, NA_GRC, NA_GUM, NA_HKG, NA_HUN, NA_ICL, NA_IND, NA_IRL, NA_IRN, NA_IRQ, NA_ISR, NA_ITA, NA_JAM, NA_JOR, NA_JPN, NA_KHM, NA_KOR, NA_LIE, NA_LTU, NA_LUX, NA_LVA, NA_MEX, NA_MYS, NA_NLD, NA_NOR, NA_NZL, NA_PAK, NA_PER, NA_PHL, NA_POL, NA_PRT, NA_ROM, NA_RUS, NA_SGP, NA_SVN, NA_SWE, NA_THA, NA_UKR, NA_USA, NA_VEN, NA_YUG, NA_ZAF	none	none	NA_USA	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.
PROCESSOR_NAME	STRING	none	none	none	empty string	The processor name is the name of the organization submitting the CASS report.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

OUTPUT_PARAMETER_OPERATOR Object

Table 8-34 OUTPUT_PARAMETER_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string	The name to use when refering to this entity in generated code.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

OUTPUT_SIGNATURE_OPERATOR Object

Table 8-35 OUTPUT_SIGNATURE_OPERATOR Object

Property	Type	Choices	Min	Max	Default
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

PIVOT_OPERATOR Object

Table 8-36 PIVOT_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
PIVOT_GROUP_SIZE	NUMBER	none	1	1000	2	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.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

PLUGGABLE_MAPPING_OPERATOR Object

Table 8-37 PLUGGABLE_MAPPING_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

POSTMAPPING_PROCESS_OPERATOR Object

Table 8-38 POSTMAPPING_PROCESS_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
FUNCTION_CALL	STRING	none	none	none	empty string	Expression template for procedure call
FUNCTION_NAME	STRING	none	none	none	empty string
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
POSTMAPPING_PROCESS_RUN_CONDITION	STRING(10)	ALWAYS, ON_ERROR, ON_SUCCESS, ON_WARNING	none	none	ON_SUCCESS	Indicates under what condition of the mapping the post-mapping process will be run.
ROW-BASED_ONLY	BOOLEAN	true, false	none	none	false	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.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SCHEMA	STRING(30)	none	none	none	empty string	Schema
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

PREMAPPING_PROCESS_OPERATOR Object

Table 8-39 PREMAPPING_PROCESS_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
FUNCTION_CALL	STRING	none	none	none	empty string	Expression template for procedure call
FUNCTION_NAME	STRING	none	none	none	empty string
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
MAPPING_RUN_CONDITION	STRING(10)	ALWAYS, ON_ERROR, ON_SUCCESS	none	none	ON_SUCCESS	Indicates under what condition of the pre-mapping process the mapping will be run.
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
ROW-BASED_ONLY	BOOLEAN	true, false	none	none	false	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.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SCHEMA	STRING(30)	none	none	none	empty string	Schema
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

QUEUE_OPERATOR Object

Table 8-40 QUEUE_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_AQ_UOID	STRING	none	none	none	empty string	The UOID of the Advanced Qeue object to which this stage component is bound to.
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
GENERATE_SUBSCRIBER	BOOLEAN	true, false	none	none	true	This only applies to batch mappings. This specifies whether the subscriber is generated. The name of the subscriber is the owning map. If the queue being sourced is a propagation queue with the same name as the owning map, then set to false.
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_REALTIME_SOURCE	BOOLEAN	true, false	none	none	false
IS_STREAMS_QUEUE	BOOLEAN	true, false	none	none	false
PAYLOAD_NAME	STRING	none	none	none	empty string	The name of payload type.
QUEUE_TABLE_NAME	STRING	none	none	none	empty string	The name of the queue table that is used to perist the messages in this Advanced Queue.
REAL_TIME_DATA_FORMAT	STRING	LOGICAL_CHANGE_RECORD, MESSAGE	none	none	MESSAGE	The format for this message, either user-defined or LCR
SOURCE_TABLES	STRING	none	none	none	empty string
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
TEMPORARY_TABLE_NAME	STRING	none	none	none	empty string	The name of the temporary table that will stage the messages from the Advanced Queue.
UDT	STRING	none	none	none	empty string
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

SEQUENCE_OPERATOR Object

Table 8-41 SEQUENCE_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SCHEMA	STRING(30)	none	none	none	empty string	Schema
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

SET_OPERATION_OPERATOR Object

Table 8-42 SET_OPERATION_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
SET_OPERATION	STRING	INTERSECT, MINUS, UNION, UNIONALL	none	none	UNION	Specifies the set operation that is to be performed by this operator.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

SORTER_OPERATOR Object

Table 8-43 SORTER_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
ORDER_BY_CLAUSE	STRING	none	none	none	empty string	The Order By Clause
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

SPLITTER_OPERATOR Object

Table 8-44 SPLITTER_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

TABLE_FUNCTION_OPERATOR Object

Table 8-45 TABLE_FUNCTION_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SCHEMA	STRING(30)	none	none	none	empty string	Schema
TABLE_FUNCTION_IS_TARGET	BOOLEAN	true, false	none	none	false	Description not available.
TABLE_FUNCTION_NAME	STRING	none	none	none	empty string	The name of the Table Function
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

TABLE_OPERATOR Object

Table 8-46 TABLE_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
ADVANCED_MATCH_BY_CONSTRAINT	STRING	none	none	none	NO_CONSTRAINTS	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.
AUTOMATIC_HINTS_ENABLED	BOOLEAN	true, false	none	none	true	Automatic hints enabled using SQL
BOUND_NAME	STRING	none	none	none	empty string	Description not available.
CDC_FILTER_CONDITION	STRING	none	none	none	--INOUTGRP1.JRN_SUBSCRIBER = 'SUNOPSIS'	Set filter to capture for a specific subscriber.
CDC_METHOD	STRING	CONSISTENT, NONE, SIMPLE	none	none	NONE	Is the change data capture method consistent or not consistent.
CHUNK_FILTER_CONDITION	STRING	none	none	none	get_chunk_iterator = 1	The filter condition used to determine the set of rows that gets processed for a specified chunk. The condition should use variable name get_chunk_iterator, which starts at one and is incremented for each chunk.
CONFLICT_RESOLUTION	BOOLEAN	true, false	none	none	true	Detect and resolve any conflicts that may arise during DML using the LCR APIs
CONTROL_CK	STRING	none	none	none	empty string	Set Control Code Template Params for Check Constraint.
CONTROL_DATA_RULES	STRING	none	none	none	empty string	Set Control Code Template Params for Data Rules.
CONTROL_FK	STRING	none	none	none	empty string	Set Control Code Template Params for Foreign Keys.
CONTROL_NN	STRING	none	none	none	empty string	Set Control Code Template Params for Not Null attributes.
CONTROL_PK	STRING	none	none	none	empty string	Set Control Code Template Params for Primary Keys.
CONTROL_UK	STRING	none	none	none	empty string	Set Control Code Template Params for Unique Keys.
DATABASE_FILE_NAME	STRING	none	none	none	empty string	Database file name to allocate extents from
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DATA_COLLECTION_FREQUENCY	STRING(16)	DAY, HOUR, MINUTE, MONTH, QUARTER, UNKNOWN, YEAR	none	none	UNKNOWN	New Data Granularity
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
DIRECT	BOOLEAN	true, false	none	none	false
DML_ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target for DML error logging.
ENABLE_CONSTRAINTS	BOOLEAN	true, false	none	none	true	Enable Constraints
ERROR_SELECT_FILTER	STRING(3)	NO, YES	none	none	YES	Rows selected from the error table will contain only errors created by this operator in this map execution
ERROR_SELECT_ROLL_UP	STRING(3)	NO, YES	none	none	YES	'Records selected from the error table will be rolled up by the error name, so all errors generated by a particular input record will be rolled up into a single record with the error names concatenated in the error name attribute.
ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target to log invalid records.
EVALUATE_CHECK_CONSTRAINTS	BOOLEAN	true, false	none	none	false	Evaluate check constraints
EXCEPTIONS_TABLE_NAME	STRING	none	none	none	empty string	Exceptions Table Name
EXTRACTION_HINT	STRING	none	none	none	empty string	Hint used when extracting from this table using SQL
HEIGHT	NUMBER	none	none	none	150
ISAPPLYSOURCE	BOOLEAN	true, false	none	none	false	Generate Non Trigger Apply uptime script considering this is a leading source for the map
IS_CDC	BOOLEAN	true, false	none	none	false	Is change data capture enabled?
IS_CHUNKING_ENABLED	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time.
IS_ERROR_TABLE	BOOLEAN	true, false	none	none	false
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_NUMBER_COLUMN_CHUNKING	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time using the number column .
IS_STATIC_TABLE	BOOLEAN	true, false	none	none	false	Check source table operator static
IS_TEMP_STAGE_TABLE	BOOLEAN	true, false	none	none	false	If set, specifies that this operator will be bound to a temporary staging table created at map deployment time. The referencing object will be ignored.
IS_TRIGGER_CDC	BOOLEAN	true, false	none	none	false	Triggers on source tables are used to capture and propagate changes.
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
JOINRANK	FLOAT	none	none	none	0	Join Rank
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
LOADING_HINT	STRING	none	none	none	empty string	Hint used when loading into this table using SQL
LOADING_TYPE	STRING(16)	CHECK_INSERT, DELETE, DELETE_INSERT, DERIVE_FROM_LCR, INSERT, INSERT_UPDATE, NONE, TRUNCATE_INSERT, UPDATE, UPDATE_INSERT	none	none	INSERT	The loading operation to be performed when this is a target.
MATCH_BY_CONSTRAINT	STRING	none	none	none	ALL_CONSTRAINTS	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.
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OBJECT_LOC_NAME	STRING	none	none	none	empty string
OBJECT_LOC_UOID	STRING	none	none	none	empty string
OBJECT_TYPE	STRING	none	none	none	empty string
OBJECT_UOID	STRING	none	none	none	empty string
OPTIMIZE_MERGE	BOOLEAN	true, false	none	none	false	Optimize the execution of expressions by deferring them until really needed
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
PARENT_OBJECT_LOC_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_LOC_UOID	STRING	none	none	none	empty string
PARENT_OBJECT_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_TYPE	STRING	none	none	none	empty string
PARENT_OBJECT_UOID	STRING	none	none	none	empty string
PARENT_OPERATOR_NAME	STRING	none	none	none	empty string
PARENT_OPERATOR_UOID	STRING	none	none	none	empty string
PARTITION_NAME	STRING	none	none	none	empty string	Partition Name
PEL_ENABLED	BOOLEAN	true, false	none	none	false	PEL Enabled
PRIMARY_SOURCE	STRING	NO, YES	none	none	NO	A boolean value to indicate whether this is a primary source or not (only used in EDW).
RECORDS_TO_SKIP	NUMBER	none	0	none	0	Number of records to skip
REPLACE_DATA	BOOLEAN	true, false	none	none	false	Replace existing data in target partition if there is any.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SAMPLE_RATE	NUMBER	none	none	none	100	The sampling rate used when selecting from this table
SAMPLE_SEED	NUMBER	none	none	none	1	The sampling seed value. The random number generator is based on this sampling seed.
SAP_TABLE_TYPE	STRING	none	none	none	empty string	SAP Table Type
SCHEMA	STRING(30)	none	none	none	empty string	Schema
SINGLEROW	BOOLEAN	true, false	none	none	false	Singlerow
SORTED_INDEXES_CLAUSE	STRING	none	none	none	empty string	Sorted Indexes Clause
SUBPARTITION_NAME	STRING	none	none	none	empty string	Subpartition Name
TARGET_FILTER_FOR_DELETE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
TARGET_FILTER_FOR_UPDATE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
TEMP_STAGE_TABLE_EXTRA_DDL_CLAUSES	STRING	none	none	none	empty string	Extra DDL clauses that will be added to the temp staging table creation DDL, after the column definitions. Example: "TABLESPACE my_tblspc"
TEMP_STAGE_TABLE_ID	STRING	none	none	none	empty string	A String ID which identifies the temp stage table within the map. It can be used to create multiple operator instances of the same temp stage table.
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
TRAILING_NULLCOLS	BOOLEAN	true, false	none	none	false	Trailing Nullcols
TRUNCATE_ERROR_TABLE	STRING(3)	NO, YES	none	none	NO	If YES, then the error table will be truncated prior to use. This is ignored if there are no active data rules applied to the object.
USE_LCR_API	BOOLEAN	true, false	none	none	true	Use LCR APIs if possible to perform the DML
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0
ZDT_DOWNTIME_EXTRACT_INDEX_NAME	STRING	none	none	none	empty string	Downtime Extraction Index Hints
ZDT_DOWNTIME_EXTRACT_INDEX_UOID	STRING	none	none	none	empty string
ZDT_UPTIME_EXTRACT_INDEX_NAME	STRING	none	none	none	empty string	Uptime Extraction Index Hints
ZDT_UPTIME_EXTRACT_INDEX_UOID	STRING	none	none	none	empty string

TRANSFORMATION_OPERATOR Object

Table 8-47 TRANSFORMATION_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
BOUND_NAME	STRING	none	none	none	empty string
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
FUNCTION_CALL	STRING	none	none	none	empty string	Expression template for procedure call
FUNCTION_NAME	STRING	none	none	none	empty string
HEIGHT	NUMBER	none	none	none	150
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
RETURN_TYPE	STRING	none	none	none	empty string	Description not available.
ROW-BASED_ONLY	BOOLEAN	true, false	none	none	false	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.
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SCHEMA	STRING(30)	none	none	none	empty string	Schema
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

UNPIVOT_OPERATOR Object

Table 8-48 UNPIVOT_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
HEIGHT	NUMBER	none	none	none	150
INLINEVIEW_HINT	STRING	none	none	none	empty string	Hint used on inline view when extracting using SQL
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0

VIEW_OPERATOR Object

Table 8-49 VIEW_OPERATOR Object

Property	Type	Choices	Min	Max	Default	Description
ADVANCED_MATCH_BY_CONSTRAINT	STRING	none	none	none	NO_CONSTRAINTS	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.
AUTOMATIC_HINTS_ENABLED	BOOLEAN	true, false	none	none	true	Automatic hints enabled using SQL
BOUND_NAME	STRING	none	none	none	empty string	The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
CDC_FILTER_CONDITION	STRING	none	none	none	--INOUTGRP1.JRN_SUBSCRIBER = 'SUNOPSIS'	Set filter to capture for a specific subscriber.
CDC_METHOD	STRING	CONSISTENT, NONE, SIMPLE	none	none	NONE	Is the change data capture method consistent or not consistent.
CHUNK_FILTER_CONDITION	STRING	none	none	none	get_chunk_iterator = 1	The filter condition used to determine the set of rows that gets processed for a specified chunk. The condition should use variable name get_chunk_iterator, which starts at one and is incremented for each chunk.
DATABASE_FILE_NAME	STRING	none	none	none	empty string	Database file name to allocate extents from
DATABASE_LINK	STRING(128)	none	none	none	empty string	The database link used to access this entity during mapping.
DB_LOCATION	STRING	none	none	none	empty string	The location used to access this entity during mapping.
DEBUG_BOUND_NAME	STRING	none	none	none	empty string	Physical name used to bind to a physical entity during a debug session
DEBUG_BRKPT_ENABLED	BOOLEAN	true, false	none	none	false
DEBUG_BRKPT_SET	BOOLEAN	true, false	none	none	false
DEBUG_DB_LOCATION	STRING(30)	none	none	none	empty string
DEBUG_USE_AS_SOURCE	BOOLEAN	true, false	none	none	false
DEBUG_WATCH_SET	BOOLEAN	true, false	none	none	false
DML_ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target for DML error logging.
ERROR_SELECT_FILTER	STRING(3)	NO, YES	none	none	YES	Rows selected from the error table will contain only errors created by this operator in this map execution
ERROR_SELECT_ROLL_UP	STRING(3)	NO, YES	none	none	YES	'Records selected from the error table will be rolled up by the error name, so all errors generated by a particular input record will be rolled up into a single record with the error names concatenated in the error name attribute.
ERROR_TABLE_NAME	STRING(32)	none	none	none	empty string	The error table name of this target to log invalid records.
EXTRACTION_HINT	STRING	none	none	none	empty string	Hint used when extracting from this table using SQL
HEIGHT	NUMBER	none	none	none	150
INLINED	BOOLEAN	true, false	none	none	false	If set to true, the view query will be used as an inline subquery in the generated code.
IS_CDC	BOOLEAN	true, false	none	none	false	Is change data capture enabled?
IS_CHUNKING_ENABLED	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time.
IS_MAXIMIZED	BOOLEAN	true, false	none	none	false
IS_MINIMIZED	BOOLEAN	true, false	none	none	false
IS_NUMBER_COLUMN_CHUNKING	BOOLEAN	true, false	none	none	false	If set, then the map will be called multiple times, processing a different chunk of the source data each time using the number column .
IS_TEMP_STAGE_TABLE	BOOLEAN	true, false	none	none	false	If set, specifies that this operator will be bound to a temporary staging table created at map deployment time. The referencing object will be ignored.
IS_TRIGGER_CDC	BOOLEAN	true, false	none	none	false	Triggers on source tables are used to capture and propagate changes.
IS_USER-DEFINED_DATA	BOOLEAN	true, false	none	none	false	If TRUE, test data for this source or target is user-defined
LEADING_SOURCE	BOOLEAN	true, false	none	none	false	If true, this source is considered the leading source when debugging the map
LOADING_HINT	STRING	none	none	none	empty string	Hint used when loading into this table using SQL
LOADING_TYPE	STRING(16)	CHECK_INSERT, DELETE, DELETE_INSERT, DERIVE_FROM_LCR, INSERT, INSERT_UPDATE, NONE, TRUNCATE_INSERT, UPDATE, UPDATE_INSERT	none	none	INSERT	The loading operation to be performed when this is a target.
MATCH_BY_CONSTRAINT	STRING	none	none	none	ALL_CONSTRAINTS	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.
METADATA_DBLINK	STRING(128)	none	none	none	empty string	Database link name in OWB repository used to capture metadata during import.
METADATA_DBLINK_IS_NEW	STRING(1)	none	none	none	N	Flag indicating reconciliation of the database link is required.
OBJECT_LOC_NAME	STRING	none	none	none	empty string
OBJECT_LOC_UOID	STRING	none	none	none	empty string
OBJECT_TYPE	STRING	none	none	none	empty string
OBJECT_UOID	STRING	none	none	none	empty string
OWNER_IM	STRING(30)	none	none	none	empty string	Owning installed module of the entity used to create this mapping component.
PARENT_OBJECT_LOC_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_LOC_UOID	STRING	none	none	none	empty string
PARENT_OBJECT_NAME	STRING	none	none	none	empty string
PARENT_OBJECT_TYPE	STRING	none	none	none	empty string
PARENT_OBJECT_UOID	STRING	none	none	none	empty string
PARENT_OPERATOR_NAME	STRING	none	none	none	empty string
PARENT_OPERATOR_UOID	STRING	none	none	none	empty string
PARTITION_NAME	STRING	none	none	none	empty string	Partition Name
PRIMARY_SOURCE	STRING	NO, YES	none	none	NO	A boolean value to indicate whether this is a primary source or not (only used in EDW).
RECORDS_TO_SKIP	NUMBER	none	0	none	0	Number of records to skip
ROW_COUNT	STRING	none	none	none	empty string	Row count
ROW_COUNT_ENABLED	BOOLEAN	true, false	none	none	false	Row count enabled
SAMPLE_RATE	NUMBER	none	none	none	100	The sampling rate used when selecting from this table
SAMPLE_SEED	NUMBER	none	none	none	1	The sampling seed value. The random number generator is based on this sampling seed.
SAP_TABLE_TYPE	STRING	none	none	none	empty string	SAP Table Type
SCHEMA	STRING(30)	none	none	none	empty string	Schema
SINGLEROW	BOOLEAN	true, false	none	none	false	Singlerow
SORTED_INDEXES_CLAUSE	STRING	none	none	none	empty string	Sorted Indexes Clause
SUBPARTITION_NAME	STRING	none	none	none	empty string	Subpartition Name
TARGET_FILTER_FOR_DELETE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
TARGET_FILTER_FOR_UPDATE	STRING	none	none	none	empty string	A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
TARGET_LOAD_ORDER	STRING(65535)	none	none	none	empty string	The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order.
TEMP_STAGE_TABLE_EXTRA_DDL_CLAUSES	STRING	none	none	none	empty string	Extra DDL clauses that will be added to the temp staging table creation DDL, after the column definitions. Example: "TABLESPACE my_tblspc"
TEMP_STAGE_TABLE_ID	STRING	none	none	none	empty string	A String ID which identifies the temp stage table within the map. It can be used to create multiple operator instances of the same temp stage table.
TEST_DATA_COLUMN_LIST	STRING	none	none	none	empty string	Column list for test data VIEW for this source or target
TEST_DATA_WHERE_CLAUSE	STRING	none	none	none	empty string	WHERE clause for test data VIEW for this source or target
TRAILING_NULLCOLS	BOOLEAN	true, false	none	none	false	Trailing Nullcols
TRUNCATE_ERROR_TABLE	STRING(3)	NO, YES	none	none	NO	If YES, then the error table will be truncated prior to use. This is ignored if there are no active data rules applied to the object.
VIEW_QUERY	STRING	none	none	none	empty string	The query text for this view.
WIDTH	NUMBER	none	none	none	180
X_COORDINATE	NUMBER	none	none	none	0
Y_COORDINATE	NUMBER	none	none	none	0