../E14406-01.epub /> ../E14406-01.mobi />

OMBCREATE PLUGGABLE_MAPPING

Purpose

Create a pluggable mapping in a project or a pluggable map folder.

Prerequisites

1. The current context of scripting must be a project or pluggable map folder.

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

3. The pluggable mapping name must not conflict with existing pluggable mapping names and the pluggable mappings names that concurrent user tries to use.

Syntax

createPluggableMappingCommand =  OMBCREATE PLUGGABLE_MAPPING 
          "pluggableMapName" [ "createOperatorOwnerDetailClause" ]
     pluggableMapName =  "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" )
     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

createPluggableMappingCommand

Create a pluggable mapping in a project or a pluggable map folder.

pluggableMapName

Name of the pluggable map.

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

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.

PLUGGABLE_MAPPING Object

Table 9-3 PLUGGABLE_MAPPING Object

Property Type Choices Min Max Default Description

DIAGRAM_LAYOUT

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.


OPERATOR Object

Table 9-4 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

 

WIDTH

NUMBER

none

none

none

180

 

X_COORDINATE

NUMBER

none

none

none

0

 

Y_COORDINATE

NUMBER

none

none

none

0

 

GROUP Object

Table 9-5 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 9-6 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 9-7 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 9-8 ANYDATA_CAST_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

 

WIDTH

NUMBER

none

none

none

180

 

X_COORDINATE

NUMBER

none

none

none

0

 

Y_COORDINATE

NUMBER

none

none

none

0

 

CONSTANT_OPERATOR Object

Table 9-9 CONSTANT_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

 

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 9-10 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 9-11 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 9-12 DATA_GENERATOR_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

 

WIDTH

NUMBER

none

none

none

180

 

X_COORDINATE

NUMBER

none

none

none

0

 

Y_COORDINATE

NUMBER

none

none

none

0

 

DEDUPLICATOR_OPERATOR Object

Table 9-13 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 9-14 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 9-15 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 9-16 EXPRESSION_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

 

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 9-17 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 9-18 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 9-19 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 9-20 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 9-21 INPUT_PARAMETER_OPERATOR Object

Property Type Choices Min Max Default Description

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 9-22 INPUT_SIGNATURE_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

 

WIDTH

NUMBER

none

none

none

180

 

X_COORDINATE

NUMBER

none

none

none

0

 

Y_COORDINATE

NUMBER

none

none

none

0

 

ITERATOR_OPERATOR Object

Table 9-23 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 9-24 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 9-25 LOOKUP_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

 

WIDTH

NUMBER

none

none

none

180

 

X_COORDINATE

NUMBER

none

none

none

0

 

Y_COORDINATE

NUMBER

none

none

none

0

 

LCRCAST_OPERATOR Object

Table 9-26 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 9-27 LCRSPLITTER_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

 

WIDTH

NUMBER

none

none

none

180

 

X_COORDINATE

NUMBER

none

none

none

0

 

Y_COORDINATE

NUMBER

none

none

none

0

 

MATCHMERGE_OPERATOR Object

Table 9-28 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 9-29 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 9-30 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 9-31 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 9-32 OUTPUT_SIGNATURE_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

 

WIDTH

NUMBER

none

none

none

180

 

X_COORDINATE

NUMBER

none

none

none

0

 

Y_COORDINATE

NUMBER

none

none

none

0

 

PIVOT_OPERATOR Object

Table 9-33 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 9-34 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 9-35 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 9-36 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 9-37 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 9-38 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 9-39 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 9-40 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 9-41 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 9-42 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 9-43 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 9-44 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 9-45 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 9-46 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