Oracle® Warehouse Builder Scripting Reference 10g Release 1 (10.1) Part Number B12152-01 |
|
|
View PDF |
This chapter contains the following topics:
OMBCREATE - Create a new component.
Should be in the context that stores the component type.
createCommand = OMBCREATE [ TRANSIENT ] "fco_type" "fco_name" [ "setPropertiesClause" ] { "setReferenceClause" } { "addSCOClause" };setPropertiesClause = SET PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setReferenceClause = SET ( REF | REFERENCE ) [ "qualifier" ] "type" "quotedNameList" [ { "parentSCOClause" } OF "fco_type" "fco_name" ];addSCOClause = ADD "sco_type" "sco_name" { "parentSCOClause" } [ "setPropertiesClause" ] { "setReferenceClause" };propertyNameList = "propertyName" { "," "propertyName" };propertyValueList = "propertyValue" { "," "propertyValue" };quotedNameList = "QUOTED_STRING" | "(" "QUOTED_STRING" { "," "QUOTED_STRING" } ")";parentSCOClause = OF "sco_type" "sco_name";propertyName = "UNQUOTED_STRING";propertyValue = "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL";
createCommand
Specify metadata for a new component.
TRANSIENT
Keyword used to specify that the object being created will not be persisted
in the repository.
fco_type
The type of the component.
fco_name
The physical name of the component in single quotes.
setPropertiesClause
Set object properties.
setReferenceClause
Specify reference objects.
qualifier
Specify which reference to set, if there are more than one pointing to the same type.
addSCOClause
Add a new child object to the component.
propertyNameList
A list of property names.
propertyValueList
A list of property values.
quotedNameList
A list of single-quoted physical names.
parentSCOClause
Used to specify the path from a child object to the component
propertyName
An unquoted string representing the name of a property.
propertyValue
The value of a property.
This is an example for creating an empty table:
OMBCREATE TABLE 'T1' SET PROPERTIES (DESCRIPTION) VALUES ('My First Table')
The following statement creates a view with a column:
OMBCREATE VIEW 'V1'
ADD COLUMN 'COL1'
SET PROPERTIES (DATATYPE) VALUES ('VARCHAR2')
OMBALTER, OMBDROP
OMBCREATE ADVANCED_QUEUE - To create an Advanced Queue.
Should be in the context of an Oracle Module. The Object Type set as Payload Type should exist in the same Oracle Module.
createAQCommand = OMBCREATE ( ADVANCED_QUEUE "QUOTED_STRING" [ SET "setPropertiesClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createAQCommand
Creates an Advanced Queue with the given name.
setPropertiesClause
Sets properties (core, logical, physical, user-defined) for Advanced Queue.
Valid properties are shown below:
Basic properties for ADVANCED_QUEUE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Advanced Queue
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Advanced Queue
Name: PAYLOAD_TYPE
Type: STRING(4000)
Valid Values: N/A
Default: ''
PayLoad Type of the Advanced Queue. This has to be the name of an Object Type(OBJECT_TYPE) existing in the same Oracle Module.
Properties for ADVANCED_QUEUE:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true.
Name: GENERATE_ADVANCED_QUEUE
Type: BOOLEAN
Valid Values: true, false
Default: true
Generate the code to create the Advanced Queue.
Name: GENERATE_OBJECT_TYPE
Type: BOOLEAN
Valid Values: true, false
Default: true
Generate a script to create the Object Type.
Name: GENERATE_QUEUE_TABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Generate code to create the queue table that will persist the messages of this Advanced Queue.
Name: GENERATE_TEMPORARY_TABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Generate the code to create the temporary table.
Name: QUEUE_TABLE_NAME
Type: STRING(30)
Valid Values: N/A
Default: ''
The name of the queue table that is used to persist the messages in this Advanced Queue.
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Use the Tablespace parameter to specify the name of tablespace.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyNameList
The list of properties.
propertyValueList
The list of property values.
propertyValue
This clause adds the property values.
OMBCREATE ADVANCED_QUEUE 'NEW_ADVANCED_QUEUE' SET PROPERTIES (DESCRIPTION, PAYLOAD_TYPE) VALUES ('this is an Advanced Queue', 'SOME_OBJECT_TYPE') This will create an Advanced Queue named "NEW_ADVANCED_QUEUE", its description is "this is an Advanced Queue" and its Payload type is Object Type 'SOME_OBJECT_TYPE'.
OMBCREATE ADVANCED_QUEUE, OMBALTER ADVANCED_QUEUE, OMBDROP ADVANCED_QUEUE
OMBCREATE COLLECTION - This is an arbitrary grouping mechanism in OWB. Any first class object can be added to the collection.
Should be in the context of a project, before creating a collection.
createCollectionCommand = OMBCREATE ( COLLECTION "QUOTED_STRING" [ SET "setPropertiesClause" ] ( { "addReferenceClause" } ) );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addReferenceClause = ADD REFERENCE TO "componentRefClause";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };componentRefClause = ( EXTERNAL_TABLE | TABLE | VIEW | MATERIALIZED_VIEW | SEQUENCE | MAPPING | DIMENSION_TABLE | CUBE_TABLE | ADVANCED_QUEUE | ORACLE_MODULE | TRANSFORMATION_MODULE | FLAT_FILE_MODULE | FLAT_FILE | PROCESS_FLOW | PROCESS_FLOW_PACKAGE | PROCESS_FLOW_MODULE | SAP_MODULE | COLLECTION | FUNCTION | PROCEDURE | PACKAGE | INTELLIGENCE_MODULE | REPORT_MODULE | REPORT | REPORT_GROUP | QUERY_OBJECT | BUSINESS_AREA | GATEWAY_MODULE | LOCATION | RUNTIME_REPOSITORY_CONNECTION | CONNECTOR | IO_FUNCTION ) "QUOTED_STRING";propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createCollectionCommand
Create a collection of objects.
setPropertiesClause
Set values for a number of properties when creating the collection.
Basic properties for COLLECTION:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the collection
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the collection
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addReferenceClause
Add a reference to the collection.
propertyNameList
Comma separated list of property names to retrieve values. Property names are unquoted.
propertyValueList
Comma separated list of property values.
componentRefClause
Specify the type of the object to reference.
propertyValue
Value of property.
OMBCREATE COLLECTION 'PURCHASING_WAREHOUSE' ADD REFERENCE TO TABLE 'PURCHASING/ORDER' ADD REFERENCE TO TABLE 'PURCHASING/CUSTOMER' OMBCREATE COLLECTION 'MY_FOLDERS' ADD REFERENCE TO ORACLE_MODULE 'PURCHASING' ADD REFERENCE TO ORACLE_MODULE 'HUMAN_RESOURCES'
OMBCREATE, OMBALTER COLLECTION, OMBDROP COLLECTION
OMBCREATE CONNECTOR - To create a connector.
Should be in the context of a location.
createConnectorCommand = OMBCREATE ( CONNECTOR "QUOTED_STRING" [ SET "setPropertiesClause" ] [ SET ( REFERENCE | REF ) "setReferenceToLocationClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setReferenceToLocationClause = LOCATION "QUOTED_STRING";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createConnectorCommand
Create a new connector.
setPropertiesClause
Set specified properties of the connector.
setReferenceToLocationClause
Set the name of the location which the connector references.
propertyNameList
The names of the properties whose values you want to set.
Properties for CONNECTOR:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyValueList
The values for the named properties.
propertyValue
A property value.
OMBCREATE CONNECTOR 'NEW_CONNECTOR' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a connector', 'connector') This will create a connector named "NEW_CONNECTOR", its description is "this is a connector", and business name is "connector".
OMBCREATE CONNECTOR 'NEW_CONNECTOR_2' SET REFERENCE LOCATION 'MY_LOCATION'
OMBCREATE, OMBALTER CONNECTOR, OMBDROP CONNECTOR
OMBCREATE CUBE_TABLE - This command creates a cube.
Should be in Oracle Module context.
OMBCreateCube = OMBCREATE CUBE_TABLE "cube_name_clause" [ "cube_properties_clause" ] { ADD "cube_addMeasure_clause" } { ADD "cube_addDimensionUse_clause" } { ADD "cube_addIndex_clause" } { ADD "cube_addPartition_clause" };cube_name_clause = "name";cube_properties_clause = "simple_properties_clause";cube_addMeasure_clause = MEASURE "cube_measure_name_clause" [ "cube_measure_properties_clause" ];cube_addDimensionUse_clause = DIMENSION_USE ( "name" [ "cube_dimensionUse_properties_clause" ] [ "cube_dimensionUse_dimension_references_clause" ] );cube_addIndex_clause = INDEX "name" [ "simple_properties_clause" ];cube_addPartition_clause = PARTITION "name" [ "simple_properties_clause" ];name = ( "QUOTED_STRING" );simple_properties_clause = SET PROPERTIES "(" "simple_property" { "," "simple_property" } ")" VALUES "(" "value" { "," "value" } ")";cube_measure_name_clause = "name";cube_measure_properties_clause = "simple_properties_clause";cube_dimensionUse_properties_clause = "simple_properties_clause";cube_dimensionUse_dimension_references_clause = SET ( REF | REFERENCE ) ( DIMENSION_TABLE "name" );simple_property = "UNQUOTED_STRING";value = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
OMBCreateCube
This command creates cube_table.
cube_name_clause
The name of the cube_table to be created.
cube_properties_clause
This clause uses the simple properties.
cube_addMeasure_clause
This clause adds the measure name and its properties.
cube_addDimensionUse_clause
This clause adds the dimensionUse and its properties.
cube_addIndex_clause
This clause adds Index name and its properties.
cube_addPartition_clause
This clause adds partition and its properties.
name
The name has to be a quoted string or an integer, or a decimal number.
simple_properties_clause
Sets properties and their values.
Basic properties for TABLE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the table
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the table
Basic properties for INDEX, PARTITION, PARTITION_KEY, INDEX_COLUMN:
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Index, Partition, PartitionKey, IndexColumn
Properties for CUBE_TABLE:
Name: ANALYZE_TABLE_ESTIMATE_PERCENT
Type: NUMBER
Valid Values: 0 - 100
Default: 99
Value represents the sample size as a percentage of total rows. When set to a nonzero value, Builder generates a DDL script to analyze the table.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: HASH_PARTITION_TABLESPACE_LIST
Type: STRING
Valid Values: N/A
Default: ''
A comma separated list of tablespaces to use for [sub]partition storage.
Name: HASH_SUBPARTITION_NUMBER
Type: NUMBER
Valid Values: 2 - 63999
Default: 2
To create Hash partition, specify the number of Hash subpartition.
Name: LOGGING_MODE
Type: STRING
Valid Values: NOLOGGING, LOGGING
Default: LOGGING
Recovery requirements for a data warehouse : Logging or not logging to Redo Log File.
Name: PARALLEL_ACCESS_MODE
Type: STRING
Valid Values: NOPARALLEL, PARALLEL
Default: PARALLEL
Enables or disables parallel processing when the table is created. Also enables or disables parallel processing or access.
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Use the Tablespace parameter to specify the name of tablespace.
Properties for INDEX:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: INDEX_TYPE
Type: STRING
Valid Values: BITMAP, UNIQUE, NO_INDEX
Default: UNIQUE
The types of Indexes created on Dimension are BITMAP, UNIQUE or a non-specific index.
Name: LOCAL_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
A local index is constructed so that it reflects the structure of the underlying table. It is equipartitioned with the underlying table, meaning that it is partitioned on the same columns as the underlying table, creates the same number of partitions or subpartitions, and gives them the same partition bounds as corresponding partitions of the underlying table.
Name: LOGGING_MODE
Type: STRING
Valid Values: NOLOGGING, LOGGING
Default: LOGGING
Recovery requirements for a data warehouse : Logging or not logging to Redo Log File.
Name: PARALLEL_ACCESS_MODE
Type: STRING
Valid Values: NOPARALLEL, PARALLEL
Default: PARALLEL
Enables or disables parallel processing when the table is created. Also enables or disables parallel processing or access.
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Use the Tablespace parameter to specify the name of tablespace.
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for PARTITION:
Name: DATE_LESS_THAN
Type: STRING
Valid Values: N/A
Default: TO_DATE('01-JAN-1999', 'DD-MON-YYYY')
Value that represents upper bound of partition stored in warehouse key column for the Days Dimension.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: EMPTY_STRING
Use the Tablespace parameter to specify the name of tablespace.
Name: VALUES_LESS_THAN
Type: STRING
Valid Values: N/A
Default: TO_DATE('01-JAN-1999', 'DD-MON-YYYY')
Noninclusive upper bound for the current partition. Type a comma separated list in the same order as the columns in range partitioned key.
Name: VALUE_LESS_THAN
Type: STRING
Valid Values: N/A
Default: ''
Noninclusive upper bound for the current partition. Type a comma separated list in the same order as the columns in range partitioned key.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
cube_measure_name_clause
name of the measure.
cube_measure_properties_clause
alters simple properties of a measure.
cube_dimensionUse_properties_clause
alters simple properties of a dimensionUse.
cube_dimensionUse_dimension_references_clause
The dimensionUse references to the first level of the dimension.
simple_property
gets the simple property.
UNQUOTED_STRING
Name of the simple property.
value
The quoted string name
OMBCREATE CUBE_TABLE 'CUBE1' ADD MEASURE 'MEASURE_1' ADD DIMENSION_USE 'CUBE1_DIM1' SET REF DIMENSION_TABLE 'DIM1'
OMBALTER CUBE_TABLE, OMBDROP CUBE_TABLE, OMBRETRIEVE CUBE_TABLE
OMBCREATE DEPLOYMENT_ACTION_PLAN - Create a deployment action plan.
There must be a current working project.
CreateActionPlanCommand = ( OMBCREATE TRANSIENT ( DEPLOYMENT_ACTION_PLAN ) "QUOTED_STRING" { "addActionClause" } );addActionClause = ADD ACTION "QUOTED_STRING" [ SET "setClause" ];setClause = ( "propertiesClause" [ SET "setReferenceClause" ] ) | "setReferenceClause";propertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setReferenceClause = ( REF | REFERENCE ) "ObjType" "QUOTED_STRING";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
CreateActionPlanCommand
Create a deployment action plan.
QUOTED_STRING
Name of the action plan in a single-quoted string. It is case-insensitive.
Must be unique within a project.
addActionClause
Add an action to an action plan.
QUOTED_STRING
Name of the action in a single-quoted string. It is case-insensitive. Must be unquie within an action plan.
setClause
Set the properties of an action and/or associate an object with an action.
propertiesClause
Associate a set of properties with an action.
PROPERTIES
The only valid property is OPERATION, which specifies the type of action to
be taken.
setReferenceClause
Associate an object with an action.
ObjType
Object type. Valid values are ADVANCED_QUEUE, CUBE_TABLE, DIMENSION_TABLE,
EXTERNAL_TABLE, CONNECTOR, FUNCTION, MAPPING, MATERIALIZED_VIEW, PROCEDURE,
PROCESS_FLOW_PACKAGE, SEQUENCE, TABLE, and VIEW.
QUOTED_STRING
Absolute or relative path name of an object (e.g. '/MY_PROJECT/MODULE_X/TABLE_Y').
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
propertyValue
Value of a property. Valid values for OPERATION are DROP and CREATE.
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN 'MY_PLAN'
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN 'MY_PLAN' ADD ACTION 'DUMMY'
OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN 'MY_PLAN'
ADD ACTION 'MY_TABLE_DEPLOY' SET PROPERTIES (OPERATION) VALUES ('DROP')
SET REFERENCE TABLE '/MY_PROJECT/MY_MODULE/MY_TABLE'
ADD ACTION 'MY_VIEW_CREATE' SET PROPERTIES (OPERATION) VALUES ('CREATE')
SET REFERENCE VIEW 'MY_MODULE/MY_VIEW'
OMBDEPLOY
OMBCREATE EXTERNAL_TABLE - To create an external table.
Should be in the context of an Oracle Module.
createExternalTableCommand = OMBCREATE ( EXTERNAL_TABLE "QUOTED_STRING" [ SET "setPropertiesAndReferencesClauses" ] [ "addExternalTableSCOClauses" ] );setPropertiesAndReferencesClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "setReferencesToRecordAndLocationClauses" ] | ( REF | REFERENCE ) "setReferencesToRecordAndLocationClauses";addExternalTableSCOClauses = ADD ( "addExternalTableColumnClause" [ "addExternalTableSCOClauses" ] | "addExternalTableDatafileClause" { ADD "addExternalTableDatafileClause" } );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setReferencesToRecordAndLocationClauses = "setReferencesToRecordFileModuleClause" [ "setReferencesToLocationClause" ] | "setReferencesToFileAndModuleClause" [ "setReferencesToLocationClause" ] | "setReferencesToLocationClause";addExternalTableColumnClause = COLUMN "QUOTED_STRING" [ SET "setPropertiesAndReferencesToFieldClauses" ];addExternalTableDatafileClause = DATA_FILE "QUOTED_STRING" [ SET "setPropertiesClause" ];propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };setReferencesToRecordFileModuleClause = RECORD "QUOTED_STRING" OF FLAT_FILE "QUOTED_STRING";setReferencesToLocationClause = DEFAULT_LOCATION "QUOTED_STRING";setReferencesToFileAndModuleClause = FLAT_FILE "QUOTED_STRING";setPropertiesAndReferencesToFieldClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "setReferencesToFieldClause" ] | ( REF | REFERENCE ) "setReferencesToFieldClause";propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );setReferencesToFieldClause = FIELD "QUOTED_STRING";
createExternalTableCommand
Create a new external table.
QUOTED_STRING
The name of the new external table.
setPropertiesAndReferencesClauses
Set the properties and/or flat file reference of the external table.
addExternalTableSCOClauses
Add columns and/or data files to the external table.
setPropertiesClause
Set specified properties of the external table.
setReferencesToRecordAndLocationClauses
Set the referenced record and/or default location.
addExternalTableColumnClause
Add an external table column.
addExternalTableDatafileClause
Add a data file to the external table.
propertyNameList
The names of the properties whose values you want to set.
Properties for EXTERNAL_TABLE:
Name: BAD_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Location to use when creating the bad file. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: BAD_FILE_NAME
Type: STRING
Valid Values: N/A
Default: ''
Name to use when creating the bad file. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
When deployable is set to true, a script to create an External Table is generated.
Name: DISCARD_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Location to use when creating the discard file. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: DISCARD_FILE_NAME
Type: STRING
Valid Values: N/A
Default: ''
Name to use when creating the discard file. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: ENDIAN
Type: STRING
Valid Values: BIG, LITTLE, PLATFORM
Default: PLATFORM
Data endian should be platform default, little or big. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: LOAD_NULLS_WHEN_MISSING_VALUES
Type: BOOLEAN
Valid Values: true, false
Default: false
If TRUE, then NULLs are loaded for any missing values in the record. If FALSE, then records with missing values are rejected. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: LOG_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Location to use when creating the log file. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: LOG_FILE_NAME
Type: STRING
Valid Values: N/A
Default: ''
Name to use when creating the log file. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: NUMBER_OF_REJECTS_ALLOWED
Type: NUMBER
Valid Values: 0 - 2147483647
Default: 0
The number of rejects allowed before processing is terminated.
Name: PARALLEL_ACCESS_DRIVERS
Type: NUMBER
Valid Values: 1 - 63999
Default: 1
The number of parallel access drivers to enable.
Name: PARALLEL_ACCESS_MODE
Type: BOOLEAN
Valid Values: true, false
Default: false
Enable or disable parallel processing.
Name: REJECTS_ARE_UNLIMITED
Type: BOOLEAN
Valid Values: true, false
Default: true
Enable or disable limiting the number of rejected records.
Name: STRING_SIZES_IN
Type: STRING
Valid Values: CHARACTERS, BYTES
Default: BYTES
String sizes are in bytes or characters. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Name: TRIM
Type: STRING
Valid Values: LEFT, NONE, SQL*LOADER, BOTH, RIGHT
Default: NONE
Specification from trim option on input fields. When the Access Parameters property is specified for the External Table, this configuration parameter is ignored.
Properties for DATA_FILE:
Name: DATA_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
The location of this data file for the external table.
Name: DATA_FILE_NAME
Type: STRING
Valid Values: N/A
Default: ''
Name of this data file.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyValueList
The values for the named properties.
setReferencesToRecordFileModuleClause
Specify the record and full path to the flat file for the external table to
reference.
setReferencesToLocationClause
The name of the external table's default location.
setReferencesToFileAndModuleClause
Specify the full path to the flat file for the external table to reference.
setPropertiesAndReferencesToFieldClauses
Set the properties and/or field reference of the external table column.
propertyValue
A property value.
setReferencesToFieldClause
Set the name of the field which the external table column references.
OMBCREATE EXTERNAL_TABLE 'SRC_TABLE' SET REFERENCE RECORD 'REC_1' OF FLAT_FILE '../SRC_FILES/FILE_1' This will create an external table named "SRC_TABLE" based upon the record "REC_1" of flat file "FILE_1" of flat file module "SRC_FILES". ombcreate_external_table$createExternalTableCommand =
OMBCREATE, OMBALTER EXTERNAL_TABLE, OMBDROP EXTERNAL_TABLE
OMBCREATE FLAT_FILE - To create a flat file.
Should be in the context of a flat file module.
createFlatFileCommand = OMBCREATE ( FLAT_FILE "QUOTED_STRING" [ SET "setPropertiesClause" ] { "addRecordClause" } );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addRecordClause = ADD ( RECORD "QUOTED_STRING" [ SET "setPropertiesClause" ] { "addFieldClause" } );propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };addFieldClause = ADD FIELD "QUOTED_STRING" [ SET "setPropertiesClause" ];propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createFlatFileCommand
Create a new flat file object.
QUOTED_STRING
The name of the new flat file.
setPropertiesClause
Set the properties of the flat file, record, or field.
addRecordClause
Add a record to the flat file.
QUOTED_STRING
The name of the new record.
propertyNameList
The names of the properties whose values you want to set.
Properties for FLAT_FILE:
Name: DATA_FILE_NAME
Type: STRING
Valid Values: N/A Default '' The name of the "sampled" file. Also the default data file value used in SQL*Loader maps and External Tables.
Name: IS_DELIMITED
Type: BOOLEAN
Valid Values: true, false, 1, 0
Default: true
True indicates that this flat file is delimited. False indicates that its fields are defined by fixed lengths
Name: CHARACTERSET
Type: STRING
Valid Values: AL24UTFFSS,AR8ARABICMAC,AR8ARABICMACS,AR8ISO8859P6,AR8MSAWIN,AR8MSWIN1256,BLT8CP921,BLT8EBCDIC1112,BLT8MSWIN1257,BLT8PC775,CDN8PC863,CL8EBCDIC1025,CL8EBCDIC1025X,CL8ISO8859P5,CL8KOI8R,CL8MACCYRILLIC,CL8MACCYRILLICS,CL8MSWIN1251,D8EBCDIC273,DK8EBCDIC277,EE8EBCDIC870,EE8ISO8859P2,EE8MACCE,EE8MACCES,EE8MACCROATIAN,EE8MACCROATIANS,EE8MSWIN1250,EE8PC852,EL8EBCDIC875,EL8ISO8859P7,EL8MACGREEK,EL8MACGREEKS,EL8MSWIN1253,EL8PC437S,EL8PC737,EL8PC869,F8EBCDIC297,I8EBCDIC280,IS8MACICELANDIC,IS8MACICELANDICS,IS8PC861,IW8EBCDIC424,IW8ISO8859P8,IW8MACHEBREW,IW8MACHEBREWS,IW8MSWIN1255,JA16EBCDIC930,JA16EUC,JA16EUCYEN,JA16MACSJIS,JA16SJIS,JA16SJISYEN,JA16VMS,KO16KSC5601,LT8MSWIN921,N8PC865,NEE8ISO8859P4,RU8PC855,RU8PC866,S8EBCDIC278,SE8ISO8859P3,TH8MACTHAI,TH8MACTHAIS,TH8TISASCII,TR8EBCDIC1026,TR8MACTURKISH,TR8MACTURKISHS,TR8MSWIN1254,TR8PC857,US7ASCII,US8PC437,UTF8,WE8EBCDIC284,WE8EBCDIC285,WE8EBCDIC37,WE8EBCDIC37C,WE8EBCDIC500,WE8EBCDIC500C,WE8EBCDIC871,WE8ISO8859P1,WE8ISO8859P9,WE8MACROMAN8,WE8MACROMAN8S,WE8MSWIN1252,WE8PC850,WE8PC860,ZHS16CGB231280,ZHS16GBK,ZHS16MACCGB231280,ZHT16BIG5,ZHT16MSWIN950,ZHT32EUC
Default: WE8MSWIN1252
The character set of the data file.
Name: RECORD_DELIMITER
Type: STRING
Valid Values: N/A
Default: ''
The character(s) which denote the end of a physical record in a data file. (Please note that this is not the FIELD_DELIMITER.
Name: RECORD_LENGTH
Type: NUMBER
Valid Values: 0+
Default: 0 (Records are delimited by default)
The length (in characters) of the records in the data file.
Name: RECORD_TYPE_COLUMN_NUMBER
Type: NUMBER
Valid Values: 0+
Default: 1
The column which contains the record type values for a delimited, multi-record type file.
Name: RECORD_TYPE_START_POSITION
Type: NUMBER
Valid Values: 0+
Default: 0
The starting position of the field (relative to 1) which contains the record type values for a fixed-length, multi-record type file.
Name: RECORD_TYPE_END_POSITION
Type: NUMBER
Valid Values: 0+
Default: 0
The ending position of the field (relative to 1) which contains the record type values for a fixed-length, multi-record type file.
Name: NUMBER_OF_RECORDS_TO_SKIP
Type: NUMBER
Valid Values: 0 - 1000
Default: 0
The default number of records to skip when loading this file.
Name: FIELD_DELIMITER
Type: STRING
Valid Values: Any single character
Default: ',' (Comma)
The character to divide the fields in a delimited file.
Name: FIELD_LEFT_ENCLOSURE
Type: STRING
Valid Values: Any single character
Default: None
A character to enclose fields which may contain the field delimiter.
Name: FIELD_RIGHT_ENCLOSURE
Type: STRING
Valid Values: Any single character
Default: None
A character to enclose fields which may contain the field delimiter.
Name: NUMBER_OF_PHYSICAL_RECORDS_PER_LOGICAL
Type: Number
Valid Values: 0+
Default: 0
Set this value if you wish to concatenate a fixed number of physical records to form a single logical record.
Name: CONTINUE_IF_ENDS_WITH
Type: STRING
Valid Values: Any single character
Default: None
Set this value if you wish to concatenate a variable number of physical records to form a single logical record, determined by records ending with this character.
Name: CONTINUE_IF_STARTS_WITH
Type: STRING
Valid Values: N/A
Default: None
Set this value if you wish to concatenate a variable number of physical records to form a single logical record, determined by records beginning with this character.
Properties for RECORD:
Name: RECORD_TYPE_VALUE
Type: STRING
Valid Values: N/A
Default: None
This is a mandatory property for each record of a multi-record type file. It is the string which will identify this record type in the data file.
Properties for FIELD:
Name: DATATYPE
Type: STRING
Valid Values: CHAR, DATE, DECIMAL EXTERNAL, FLOAT EXTERNAL, INTEGER EXTERNAL, ZONED EXTERNAL, ZONED
Default: CHAR
This is the SQL*Loader data type for the field.
Name: LENGTH
Type: NUMBER
Valid Values: 1+
Default: 1
This is the length of the field in a fixed length file. This is the max length of the field in a delimited file.
Name: PRECISION
Type: NUMBER
Valid Values: Depends on data type
Default: 0
Precision of the field.
Name SCALE
Type: NUMBER
Valid Values: Depends on data type
Default: 0
Scale of the field
Name: START_POSITION
Type: NUMBER
Valid Values: 0+
Default: 0
The starting position of a field for a fixed length file.
Name: SQL_DATATYPE
Type: STRING
Valid Values: CHAR, DATE, FLOAT, NUMBER, VARCHAR, VARCHAR2, DEFAULT
Default: DEFAULT. This will derive the SQL_DATATYPE from the value of
DATATYPE. The data type which the field will be treated as in mapping and for External Tables.
Name: SQL_LENGTH
Type: NUMBER
Valid Values: for 'CHAR' : 1 - 2000 for 'VARCHAR' and 'VARCHAR2' : 1 - 4000
Default: Depends on Sql data type.
Name: SQL_PRECISION
Type: NUMBER
Valid Values: 1 - 38
Default: 1
Name: SQL_SCALE
Type: NUMBER
Valid Values: -84 - 127
Default: 0
Name: MASK
Type: STRING
Valid Values: N/A
Default: None
This is the mask used to define the format of DATE fields in the data file.
Name: NULL_IF
Type: STRING
Valid Values: Either = or != followed by either 'BLANKS', a single quoted string, or a hexadecimal string
Default: None
If this condition is true for a field, the value loaded will be NULL.
Name: DEFAULT_IF
Type: STRING
Valid Values: Either = or != followed by either 'BLANKS', a single quoted string, or a hexadecimal string
Default: None
If this condition is true for a field, the value loaded will be either NULL or 0, dependent on data type.
propertyValueList
The values for the named properties.
addFieldClause
Add a field to the record.
QUOTED_STRING
The name of the new field.
propertyValue
A property value.
OMBCREATE FLAT_FILE 'SRC_FILE' \
SET PROPERTIES (DATA_FILE_NAME, FIELD_DELIMITER, FIELD_LEFT_ENCLOSURE, FIELD_RIGHT_ENCLOSURE, RECORD_TYPE_COLUMN_NUMBER) \ VALUES ('src_data.dat', '|', '{', '}', 1) \ ADD RECORD 'REC1' \ SET PROPERTIES (RECORD_TYPE_VALUE) VALUES ('E') \ ADD FIELD 'F1' \ SET PROPERTIES (DATATYPE, MASK) VALUES ('DATE', 'dd-mon-yyyy') \ ADD FIELD 'F2' \ ADD RECORD 'REC2' \ SET PROPERTIES (RECORD_TYPE_VALUE) VALUES ('P') \ ADD FIELD 'F1' \ ADD FIELD 'F2' \ ADD FIELD 'F3' This will create a flat file named "SRC_FILE" with multiple record types.
OMBCREATE, OMBALTER FLAT_FILE, OMBDROP FLAT_FILE
OMBCREATE FLAT_FILE_MODULE - To create a flat file module.
Should be in the context of project.
createFlatFileModuleCommand = OMBCREATE ( FLAT_FILE_MODULE "QUOTED_STRING" [ SET ( "setPropertiesClause" [ SET "setReferenceLocationClause" ] | "setReferenceLocationClause" ) ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setReferenceLocationClause = ( REFERENCE | REF ) LOCATION "QUOTED_STRING";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createFlatFileModuleCommand
Create a new flat file module.
QUOTED_STRING
The name for the new flat file module.
setPropertiesClause
Set specified properties of the new flat file module.
setReferenceLocationClause
Set the location for the new flat file module to the location specified by the quoted string.
propertyNameList
The names of the properties whose values you want to set.
Basic properties for FLAT_FILE_MODULE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: NAME
Business name of the flat file module.
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the flat file module.
Name: UOID
Type: STRING(40)
Valid Values: N/A
Default: N/A
UOID of the flat file module.
propertyValueList
The values for the named properties.
propertyValue
A property value.
OMBCREATE FLAT_FILE_MODULE 'src_module' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a flat file module', 'source module') This will create a flat file module named "src_module", its description is "this is a flat file module", and business name is "source module".
OMBCREATE, OMBALTER FLAT_FILE_MODULE, OMBDROP FLAT_FILE_MODULE
OMBCREATE FUNCTION - To create a Function.
Should be in the context of a Oracle Module or Package or Transformation Module.
createFunctionCommand = OMBCREATE ( FUNCTION "QUOTED_STRING" [ SET "setPropertiesClause" ] { ADD "addFuncProcParameterClause" } );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addFuncProcParameterClause = PARAMETER "QUOTED_STRING" [ SET "setPropertiesClause" ];propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createFunctionCommand
This command creates a Function
QUOTED_STRING
Name of the Function to be created.
setPropertiesClause
Used to set properties (core, user-defined) for function. Valid properties are shown below:
Basic properties for FUNCTION:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Function
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Function
Name: RETURN_TYPE
Type: STRING
Valid Values: PLS_INTEGER, BINARY_INTEGER, BOOLEAN, NUMBER, FLOAT, CHAR, VARCHAR, VARCHAR2, DATE
Default: NUMBER
Set the Return Type for Function
Name: IMPLEMENTATION
Type: STRING
Valid Values: N/A
Default: ''
Set the code for Function which is included global variable declaration and code between BEGIN and END.
Name: IS_DETERMINISTIC
Type: BOOLEAN
Valid Values: true, false
Default: false
This setting helps the optimizer avoid redundant function calls.
Name: IS_PARALLEL_ENABLE
Type: BOOLEAN
Valid Values: true, false
Default: false
This option sets flag to a stored function can be used safely in the slave sessions of parallel DML evaluations.
Basic properties for PARAMETER:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Parameter
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Parameter
Name: DATATYPE
Type: STRING
Valid Values: PLS_INTEGER, BINARY_INTEGER, BOOLEAN, NUMBER, FLOAT, CHAR, VARCHAR, VARCHAR2, DATE
Default: NUMBER
Set the data type for Parameter
Name: IN_OUT
Type: STRING
Valid Values: IN, OUT, INOUT
Default: 'IN'
Set the parameter mode for Parameter
Name: DEFAULT_VALUE
Type: STRING
Valid Values: N/A
Default: ''
Set the default value for Parameter
Properties for FUNCTION:
Name: AUTHID
Type: STRING
Valid Values: None, Current_User, Definer
Default: None
Generate the transformation with selected AUTHID option. Function will be executed with the permissions defined by the AUTHID clause rather than the function owner's permissions.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addFuncProcParameterClause
Adds one or more Parameters to this Function.
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
propertyValue
Value of a property.
OMBCREATE FUNCTION 'func' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME, RETURN_TYPE, IMPLEMENTATION, IS_DETERMINISTIC, IS_PARALLEL_ENABLE) VALUES ('this is a Function', 'function', 'NUMBER', 'BEGIN RETURN 1 END func \;', 'true', 'true') ADD PARAMETER 'PARAM_1' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME, IN_OUT, DATATYPE, DEFAULT_VALUE) VALUES ('param_1', 'this is a param_1','IN', 'VARCHAR2', 'this is a Varchar2') ADD PARAMETER 'PARAM_2' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME, IN_OUT, DATATYPE, DEFAULT_VALUE) VALUES ('param_2', 'this is a param_2','INOUT', 'DATE', 'this is a Date') This will create a Function named "func", its description is "this is a Function", and business name is "function", return datatype NUMBER, and body of function as 'BEGIN RETURN 1 END func;'. It creates two parameters 'PARAM_1' and 'PARAM_2'
OMBCREATE, OMBALTER FUNCTION, OMBDROP FUNCTION
OMBCREATE LOCATION - To create a location.
Should be in the context of a project.
createLocationCommand = OMBCREATE ( LOCATION "QUOTED_STRING" "createLocationSetPropertiesClause" );createLocationSetPropertiesClause = SET PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createLocationCommand
Create a new location.
createLocationSetPropertiesClause
Set specified properties of the new location.
propertyNameList
The names of the properties whose values you want to set.
Properties for LOCATION:
Name: TYPE
Type: STRING
Valid Values: 'Oracle Gateway', 'File System', 'Oracle Database', 'OEM Agent', 'Oracle Workflow', 'SAP'
Default: N/A
The type of system the location represents.
Name: VERSION
Type: STRING
Valid Values:
for 'Oracle Gateway' : '0'
for 'File System' : '0'
for 'Oracle Database' : '9.2','9.0','8.1','8.0','7.3.4'
for 'OEM Agent' : '9.2','9.0'
for 'Oracle Workflow' : '2.6'
for 'SAP' : '4.x','3.x'
Default: N/A
The version of the system(s) the location represents.
Basic properties for LOCATION:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the location.
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the location.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyValueList
The values for the named properties.
propertyValue
A property value.
OMBCREATE LOCATION 'MY_LOCATION' SET PROPERTIES (TYPE, VERSION, DESCRIPTION, BUSINESS_NAME) VALUES ('Oracle Database', '9.2','this is a location', 'location') This will create a location named "MY_LOCATION". Its type is "Oracle Database", version is "9.2", description is "this is a location", and business name is "location".
OMBCREATE, OMBALTER LOCATION, OMBDROP LOCATION
OMBCREATE MAPPING - Create a mapping in an Oracle Module.
1. The current context of scripting must be an Oracle Module.
2. No concurrent user should be locking the Oracle Module or any of its ancestors exclusively at the moment the map is being created. 3. The map name must not conflict with existing map names and the maps names that concurrent user tries to use.
createMappingCommand = OMBCREATE MAPPING "mappingName" [ "setPropertiesClause" ] { ADD ( "addOperatorClause" | "addGroupClause" | "addAttributeClause" | "addChildClause" | "addConnectionClause" ) };mappingName = "QUOTED_STRING";setPropertiesClause = SET PROPERTIES "propertyKeyList" VALUES "propertyValueList";addOperatorClause = "operatorType" OPERATOR "operatorName" [ "setPropertiesClause" ] [ "setBindingClause" ];addGroupClause = "groupDirection" GROUP "groupName" OF "operatorLocator" [ "setPropertiesClause" ];addAttributeClause = ATTRIBUTE "attributeName" OF "groupBottomUpLocator" [ "setPropertiesClause" ];addChildClause = "childType" "childName" "childOwnerBottomUpLocator" [ "setPropertiesClause" ];addConnectionClause = CONNECTION FROM ( "groupBottomUpLocator" TO "groupBottomUpLocator" [ "groupToGroupConnectType" ] | "attributeBottomUpLocator" TO ( "attributeBottomUpLocator" | "attributesBottomUpLocator" | "groupBottomUpLocator" ) | "attributesBottomUpLocator" TO ( "attributesBottomUpLocator" | "groupBottomUpLocator" ) );propertyKeyList = "(" "propertyKey" { "," "propertyKey" } ")";propertyValueList = "(" "propertyValue" { "," "propertyValue" } ")";operatorType = "UNQUOTED_STRING";operatorName = "QUOTED_STRING";setBindingClause = BOUND TO "bindableLocator";groupDirection = INPUT | OUTPUT | INPUT_OUTPUT;groupName = "QUOTED_STRING";operatorLocator = OPERATOR "operatorName";attributeName = "QUOTED_STRING";groupBottomUpLocator = GROUP "groupName" OF "operatorLocator";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";propertyKey = "UNQUOTED_STRING";propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );bindableLocator = "bindableType" "bindableName";mappableBottomUpLocator = "operatorLocator" | "groupBottomUpLocator" | "attributeBottomUpLocator";attributeNameList = "(" "attributeName" { "," "attributeName" } ")";bindableType = "UNQUOTED_STRING";bindableName = "QUOTED_STRING";
createMappingCommand
Create a mapping in an Oracle Module.
mappingName
Name of the mapping.
setPropertiesClause
Describe the keys of properties for the map or objects in the map.
addOperatorClause
Adds a mapping operator to a map. When you add an operator, Warehouse Builder creates default groups and parameters for the operator. Please see the appendix section of the Scripting Reference.
The following is an example for creating a child object under a mapping (which is not an operator) OMBALTER MAPPING 'M1' ADD SOURCE_DATA_FILE 'FILE1'
The following is an example for creating an operator:
OMBALTER MAPPING 'M1' ADD TABLE OPERATOR 'T1'
In the second example, when user forgets to type "OPERATOR" "GROUP" "ATTRIBUTE" key word, instead of complaining the keywords are missing, OMBPlus will complain about error getting child objects. Here is an example: OMB+> OMBALTER MAPPING 'M1' ADD TABLE 'T1' OMB02932: Error getting child objects of type TABLE in M1
TO A USER: it looks like OMBPlus should complain they forget to type a keyword.
TO OMBPLUS: the syntax is actually for creating a non-operator child object
under the mapping. Therefore, it goes and tries to find type definition for
non-operator child object "TABLE" and cannot find it. Therefore the exception is thrown.
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.
addConnectionClause
Add connections between mapping groups or mapping attributes.
propertyKeyList
The list of property keys
propertyValueList
A list of property values.
operatorType
Type of a mapping operator. The following operator types are available: ADVANCED_QUEUE, AGGREGATOR, CONSTANT, CUBE, DATA_GENERATOR, DEDUPLICATOR, DIMENSION, EXPRESSION, EXTERNAL_PROCESS, EXTERNAL_TABLE, FILTER, FLAT_FILE, INPUT_PARAMETER, JOINER, KEY_LOOKUP, MATCHMERGE, MATERIALIZED_VIEW, NAME_AND_ADDRESS, OUTPUT_PARAMETER, PIVOT, POSTMAPPING_PROCESS, PREMAPPING_PROCESS, SEQUENCE, SET_OPERATION, SORTER, SPLITTER, TABLE, TRANSFORMATION, UNPIVOT, VIEW.
operatorName
Name of a mapping operator.
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.
operatorLocator
Location of a mapping 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.
propertyKey
A property key for an object.
Basic properties for MAPPING:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the mapping
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the mapping
Basic properties for OPERATOR:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the operator
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the operator
Basic properties for GROUP:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the group
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the group
Basic properties for ATTRIBUTE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the attribute
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the attribute
Name: DATATYPE
Type: STRING(20)
Valid Values: NUMBER, VARCHAR2, VARCHAR, DATE, LONG
Default: ''
Datatype of the Attribute
Name: LENGTH
Type: NUMBER
Valid Values: N/A
Default: 0
Length of the attribute.
Name: PRECISION
Type: NUMBER
Valid Values: N/A
Default: 0
Precision of the attribute.
Name: SCALE
Type: NUMBER
Valid Values: N/A
Default: 0
Scale of the attribute.
Properties for MAPPING:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: STEP_TYPE
Type: STRING
Valid Values: ABAP, SQLLOADER, PLSQL
Default: UNKNOWN
The step type used to generate this mapping
Properties for MAPPING ABAP STEP:
Name: CONTROL_FILE_NAME
Type: STRING
Valid Values: N/A
Default: owb.dat
Control File Name
Name: DATA_FILE_NAME
Type: STRING
Valid Values: N/A
Default: owb.dat
Data File Name
Name: FILE_DELIMITER_FOR_STAGING_FILE
Type: STRING
Valid Values: N/A
Default: ~
File Delimiter for Staging File
Name: LOG_FILE_NAME
Type: STRING
Valid Values: N/A
Default: owb.log
Log File Name
Name: NESTED_LOOP
Type: STRING
Valid Values: TRUE_DEFAULT, TRUE, FALSE
Default: TRUE_DEFAULT
Nested Loop
Name: PRIMARY_FOREIGN_KEY_FOR_JOIN
Type: STRING
Valid Values: N/A
Default: DEFAULT
Primary Foreign Key for Join
Name: SAP_SYSTEM_VERSION
Type: STRING
Valid Values: SAP_R3_4X, SAP_R3_3X
Default: SAP_R3_4X
SAP System Version
Name: SQL_JOIN_COLLAPSING
Type: STRING
Valid Values: TRUE_DEFAULT, TRUE, FALSE
Default: TRUE_DEFAULT
Sql Join Collapsing
Name: STAGING_FILE_DIRECTORY
Type: STRING
Valid Values: N/A
Default: C:\temp\
Staging File Directory
Name: USE_SELECT_SINGLE
Type: STRING
Valid Values: TRUE_DEFAULT, TRUE, FALSE
Default: TRUE_DEFAULT
Use Select Single
Properties for MAPPING PLSQL STEP:
Name: ANALYZE_TABLE_SAMPLE_PERCENTAGE
Type: NUMBER
Valid Values: N/A
Default: 90
The default percentage of rows to be sampled when the target tables are analyzed for statistics to improve performance during insertion.
Name: ANALYZE_TABLE_STATEMENTS
Type: BOOLEAN
Valid Values: true, false
Default: true
Generate statistics collection statement if this is true.
Name: BULK_PROCESSING_CODE
Type: BOOLEAN
Valid Values: true, false
Default: true
Generate bulk processing code if this is true.
Name: BULK_SIZE
Type: NUMBER
Valid Values: N/A
Default: 50
The default number of rows to be fetched in batch during cursor processing.
Name: COMMIT_FREQUENCY
Type: NUMBER
Valid Values: N/A
Default: 1000
The default number of rows processed before a commit is issued.
Name: CORRELATED_COMMIT
Type: BOOLEAN
Valid Values: true, false
Default: false
The mapping commits or rolls back correlated rows together.
Name: DEFAULT_AUDIT_LEVEL
Type: STRING
Valid Values: NONE, STATISTICS, ERROR_DETAILS, COMPLETE
Default: ERROR_DETAILS
The default audit level when the step is executed.
Name: DEFAULT_OPERATING_MODE
Type: STRING
Valid Values: SET_BASED, ROW_BASED, ROW_BASED_TARGET_ONLY, SET_BASED_FAIL_OVER_TO_ROW_BASED, SET_BASED_FAIL_OVER_TO_ROW_BASED_TARGET_ONLY
Default: SET_BASED_FAIL_OVER_TO_ROW_BASED
The default operating mode.
Name: DEFAULT_PURGE_GROUP
Type: STRING
Valid Values: N/A
Default: WB
The default purge group to be used when the step is executed.
Name: MAXIMUM_NUMBER_OF_ERRORS
Type: NUMBER
Valid Values: N/A
Default: 50
The default maximum number of errors encountered before aborting the step execution.
Name: OPTIMIZED_CODE
Type: BOOLEAN
Valid Values: true, false
Default: true
Attempt to generate optimized code if this is true.
Name: PARALLEL_ROW_CODE
Type: BOOLEAN
Valid Values: true, false
Default: false
Generate parallel row code if this is true.
Properties for MAPPING SQLLOADER STEP:
Name: AUDIT
Type: BOOLEAN
Valid Values: true, false
Default: true
Perform audit when the step is executed.
Name: BIND_SIZE
Type: NUMBER
Valid Values: N/A
Default: 50000
Bind Size
Name: CONTINUE_LOAD
Type: BOOLEAN
Valid Values: true, false
Default: false
Continue Load
Name: CONTROL_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: N/A
The Control File Location
Name: CONTROL_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The control file name used in TCL generation
Name: DATABASE_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Database file name from which to allocate extents
Name: DEFAULT_PURGE_GROUP
Type: STRING
Valid Values: N/A
Default: WB
The default purge group to be used when the step is executed.
Name: DELIMITED_FILE_RECORD_TERMINATION
Type: STRING
Valid Values: N/A
Default: N/A
This property has been deprecated. Please set the record delimiter in the Flat File Sample Wizard or Property Sheet.
Name: DIRECT_MODE
Type: BOOLEAN
Valid Values: true, false
Default: true
Direct Mode
Name: ERRORS_ALLOWED
Type: NUMBER
Valid Values: N/A
Default: 50
Number of errors to allow
Name: LOG_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: N/A
The log file location.
Name: LOG_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The log file name.
Name: NLS_CHARACTERSET
Type: STRING
Valid Values: AL24UTFFSS, AR8ARABICMAC, AR8ARABICMACS, AR8ISO8859P6, AR8MSAWIN, AR8MSWIN1256, BLT8CP921, BLT8EBCDIC1112, BLT8MSWIN1257, BLT8PC775, CDN8PC863, CL8EBCDIC1025, CL8EBCDIC1025X, CL8ISO8859P5, CL8KOI8R, CL8MACCYRILLIC, CL8MACCYRILLICS, CL8MSWIN1251, D8EBCDIC273, DK8EBCDIC277, EE8EBCDIC870, EE8ISO8859P2, EE8MACCE, EE8MACCES, EE8MACCROATIAN, EE8MACCROATIANS, EE8MSWIN1250, EE8PC852, EL8EBCDIC875, EL8ISO8859P7, EL8MACGREEK, EL8MACGREEKS, EL8MSWIN1253, EL8PC437S, EL8PC737, EL8PC869, F8EBCDIC297, I8EBCDIC280, IS8MACICELANDIC, IS8MACICELANDICS, IS8PC861, IW8EBCDIC424, IW8ISO8859P8, IW8MACHEBREW, IW8MACHEBREWS, IW8MSWIN1255, JA16EBCDIC930, JA16EUC, JA16EUCYEN, JA16MACSJIS, JA16SJIS, JA16SJISYEN, JA16VMS, KO16KSC5601, LT8MSWIN921, N8PC865, NEE8ISO8859P4, RU8PC855, RU8PC866, S8EBCDIC278, SE8ISO8859P3, TH8MACTHAI, TH8MACTHAIS, TH8TISASCII, TR8EBCDIC1026, TR8MACTURKISH, TR8MACTURKISHS, TR8MSWIN1254, TR8PC857, US7ASCII, US8PC437, UTF8, WE8EBCDIC284, WE8EBCDIC285, WE8EBCDIC37, WE8EBCDIC37C, WE8EBCDIC500, WE8EBCDIC500C, WE8EBCDIC871, WE8ISO8859P1, WE8ISO8859P9, WE8MACROMAN8, WE8MACROM AN8S, WE8MSWIN1252, WE8PC850, WE8PC860, ZHS16CGB231280, ZHS16GBK, ZHS16MACCGB231280, ZHT16BIG5, ZHT16MSWIN950, ZHT32EUC
Default: WE8MSWIN1252
Nls Characterset
Name: OPERATION_RECOVERABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Operation Recoverable
Name: PERFORM_PARALLEL_LOAD
Type: BOOLEAN
Valid Values: true, false
Default: false
Perform Parallel Load
Name: PRESERVE_BLANKS
Type: BOOLEAN
Valid Values: true, false
Default: false
Preserve Blanks
Name: READ_BUFFERS
Type: NUMBER
Valid Values: N/A
Default: 4
The Number of Buffers
Name: READ_SIZE
Type: NUMBER
Valid Values: N/A
Default: 65536
The size of the read buffer
Name: RECORDS_TO_LOAD
Type: NUMBER
Valid Values: N/A
Default: N/A
Number of logical records to load. The default value of 0 indicates to load all records.
Name: RECORDS_TO_SKIP
Type: NUMBER
Valid Values: N/A
Default: N/A
Number of logical records to skip
Name: ROWS_PER_COMMIT
Type: NUMBER
Valid Values: N/A
Default: 200
Rows per Commit
Properties for MAPPING SQLLOADER STEP SOURCE_DATA_FILE CHILD:
Name: BAD_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: N/A
Bad file location.
Name: BAD_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Bad file name. If the Bad File Location is set then this must be a relative file name. Otherwise this should contain a fully qualified path.
Name: DATA_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: N/A
The location for this component.
Name: DATA_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The data file name for this component. If the Data File Location is set then this must be a relative file name. Otherwise this should contain a fully qualified path.
Name: DISCARD_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: N/A
Discard file location
Name: DISCARD_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Discard file name. If the Discard File Location is set then this must be a relative file name. Otherwise this should contain a fully qualified path.
Name: DISCARD_MAX
Type: NUMBER
Valid Values: N/A
Default: 0
Discard Max
Properties for ADVANCED_QUEUE OPERATOR:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Properties for AGGREGATOR OPERATOR:
Name: GROUP_BY_CLAUSE
Type: STRING
Valid Values: N/A
Default: N/A
The Group By clause for the aggregation
Name: HAVING_CLAUSE
Type: STRING
Valid Values: N/A
Default: N/A
The Having clause for the aggregation
Properties for CUBE OPERATOR:
Name: ADVANCED_MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: 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.
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Database file name to allocate extents from
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: DATA_COLLECTION_FREQUENCY
Type: STRING
Valid Values: UNKNOWN, YEAR, QUARTER, MONTH, DAY, HOUR, MINUTE
Default: UNKNOWN
New Data Granularity
Name: DIRECT
Type: BOOLEAN
Valid Values: true, false
Default: false
Directly swap source into target as a partition without first creating a staging table.
Name: ENABLE_CONSTRAINTS
Type: BOOLEAN
Valid Values: true, false
Default: true
Enable Constraints
Name: EXCEPTIONS_TABLE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Exceptions Table Name
Name: EXTRACTION_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when extracting from this table using SQL
Name: LOADING_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when loading into this table using SQL
Name: LOADING_TYPE
Type: STRING
Valid Values: INSERT, UPDATE, INSERT_UPDATE, UPDATE_INSERT, DELETE, NONE, TRUNCATE_INSERT, DELETE_INSERT, CHECK_INSERT
Default: INSERT
The loading operation to be performed when this is a target.
Name: MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: YES
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.
Name: PARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Partition Name
Name: PEL_ENABLED
Type: BOOLEAN
Valid Values: true, false
Default: false
PEL Enabled
Name: PRIMARY_SOURCE
Type: STRING
Valid Values: YES, NO
Default: NO
A boolean value to indicate whether this is a primary source or not (only used in EDW).
Name: RECORDS_TO_SKIP
Type: NUMBER
Valid Values: N/A
Default: N/A
Number of records to skip
Name: REPLACE_DATA
Type: BOOLEAN
Valid Values: true, false
Default: false
Replace existing data in target partition if there is any.
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Name: SINGLEROW
Type: BOOLEAN
Valid Values: true, false
Default: false
Singlerow
Name: SORTED_INDEXES_CLAUSE
Type: STRING
Valid Values: N/A
Default: N/A
Sorted Indexes Clause
Name: SUBPARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Subpartition Name
Name: TARGET_FILTER_FOR_DELETE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
Name: TARGET_FILTER_FOR_UPDATE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
Name: TRAILING_NULLCOLS
Type: BOOLEAN
Valid Values: true, false
Default: false
Trailing Nullcols
Properties for DIMENSION OPERATOR:
Name: ADVANCED_MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: 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.
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Database file name to allocate extents from
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: DATA_COLLECTION_FREQUENCY
Type: STRING
Valid Values: UNKNOWN, YEAR, QUARTER, MONTH, DAY, HOUR, MINUTE
Default: UNKNOWN
New Data Granularity
Name: DIRECT
Type: BOOLEAN
Valid Values: true, false
Default: false
Directly swap source into target as a partition without first creating a staging table.
Name: ENABLE_CONSTRAINTS
Type: BOOLEAN
Valid Values: true, false
Default: true
Enable Constraints
Name: EXCEPTIONS_TABLE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Exceptions Table Name
Name: EXTRACTION_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when extracting from this table using SQL
Name: LOADING_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when loading into this table using SQL
Name: LOADING_TYPE
Type: STRING
Valid Values: INSERT, UPDATE, INSERT_UPDATE, UPDATE_INSERT, DELETE, NONE, TRUNCATE_INSERT, DELETE_INSERT, CHECK_INSERT
Default: INSERT
The loading operation to be performed when this is a target.
Name: MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: YES
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.
Name: PARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Partition Name
Name: PEL_ENABLED
Type: BOOLEAN
Valid Values: true, false
Default: false
PEL Enabled
Name: PRIMARY_SOURCE
Type: STRING
Valid Values: YES, NO
Default: NO
A boolean value to indicate whether this is a primary source or not (only used in EDW).
Name: RECORDS_TO_SKIP
Type: NUMBER
Valid Values: N/A
Default: N/A
Number of records to skip
Name: REPLACE_DATA
Type: BOOLEAN
Valid Values: true, false
Default: false
Replace existing data in target partition if there is any.
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Name: SINGLEROW
Type: BOOLEAN
Valid Values: true, false
Default: false
Singlerow
Name: SORTED_INDEXES_CLAUSE
Type: STRING
Valid Values: N/A
Default: N/A
Sorted Indexes Clause
Name: SUBPARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Subpartition Name
Name: TARGET_FILTER_FOR_DELETE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
Name: TARGET_FILTER_FOR_UPDATE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
Name: TRAILING_NULLCOLS
Type: BOOLEAN
Valid Values: true, false
Default: false
Trailing Nullcols
Properties for EXTERNAL_TABLE OPERATOR:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: EXTRACTION_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when extracting from this table using SQL
Name: LOADING_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when loading into this table using SQL
Name: PRIMARY_SOURCE
Type: STRING
Valid Values: YES, NO
Default: NO
A boolean value to indicate whether this is a primary source or not (only used in EDW).
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Properties for FILTER OPERATOR:
Name: FILTER_CONDITION
Type: STRING
Valid Values: N/A
Default: N/A
The boolean filtering condition that identifies what data is to be processed. Any row with a false condition will be ignored.
Properties for FLAT_FILE OPERATOR:
Name: CONCATENATE_RECORDS
Type: NUMBER
Valid Values: N/A
Default: 0
Number of Physical Records per Logical Record.
Name: CONTINUATION_CHARACTER
Type: STRING
Valid Values: N/A
Default: N/A
Character that indicates the record is continued on the next line.
Name: CONTINUATION_CHARACTER_ON_NEXT_LINE
Type: BOOLEAN
Valid Values: true, false
Default: FALSE
If there is a continuation character, is it at the start of the line.
Name: FIELD_ENCLOSURE_CHARACTERS
Type: STRING
Valid Values: N/A
Default: N/A
Characters that wrap fields. Example ' or ".
Name: FIELD_NAMES_IN_THE_FIRST_ROW
Type: BOOLEAN
Valid Values: true, false
Default: FALSE
Indicates whether to write the field names in the first row of the output file.
Name: FIELD_TERMINATION_CHARACTER
Type: STRING
Valid Values: N/A
Default: ,
Character that separates the fields of a delimited file.
Name: FILE_FORMAT
Type: STRING
Valid Values: N/A
Default: DELIMITED
File Format (Fixed or Delimited).
Name: LOADING_TYPE
Type: STRING
Valid Values: INSERT, UPDATE, NONE
Default: INSERT
The loading operation to be performed
Name: NLS_CHARACTERSET
Type: STRING
Valid Values: N/A
Default: WE8MSWIN1252
NLS Characterset
Name: RECORD_DELIMITER
Type: STRING
Valid Values: N/A
Default: N/A
Character that indicates the end of the record.
Name: RECORD_SIZE
Type: NUMBER
Valid Values: N/A
Default: 0
Size of a fixed length record.
Name: RECORD_TYPE_LENGTH
Type: NUMBER
Valid Values: N/A
Default: 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.
Name: RECORD_TYPE_POSITION
Type: NUMBER
Valid Values: N/A
Default: 0
If this is a multi record file, this will indicate the position of the field that identifies the type of record.
Name: SAMPLED_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name of the file that was sampled to get the metadata for this file.
Name: TARGET_DATA_FILE_LOCATION
Type: STRING
Valid Values: N/A
Default: N/A
The name of the location in which to open the target data file. Make sure the root path of this location, as registered in the Runtime Platform, is exactly specified in the initialization file (INIT.ORA) of your runtime database using the UTL_FILE_DIR parameter.
Name: TARGET_DATA_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
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.
Properties for INPUT_PARAMETER OPERATOR:
Properties for JOINER OPERATOR:
Name: JOIN_CONDITION
Type: STRING
Valid Values: N/A
Default: N/A
The Join Condition for the join operator
Properties for KEY_LOOKUP OPERATOR:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: LOOKUP_CONDITION
Type: STRING
Valid Values: N/A
Default: N/A
Key lookup condition based on the source inputs. This condition is used to lookup a value in the bound table. If the condition is not met, the default value expression will be returned. If a default expression is not defined, null is used.
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Properties for MATCHMERGE OPERATOR:
Name: MATCH_KEYS
Type: STRING
Valid Values: N/A
Default: N/A
Ordered list of attributes that control the set of records to be matched at any at any particular time.
Name: MERGED_PREFIX
Type: STRING
Valid Values: N/A
Default: N/A
Set the prefix used for the merged attributes in the cross-reference group.
Properties for MATERIALIZED_VIEW OPERATOR:
Name: ADVANCED_MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: 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.
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: EXTRACTION_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when extracting from this table using SQL
Name: LOADING_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when loading into this table using SQL
Name: LOADING_TYPE
Type: STRING
Valid Values: INSERT, UPDATE, INSERT_UPDATE, UPDATE_INSERT, DELETE, NONE, TRUNCATE_INSERT, DELETE_INSERT, CHECK_INSERT
Default: INSERT
The loading operation to be performed when this is a target.
Name: MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: YES
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.
Name: PRIMARY_SOURCE
Type: STRING
Valid Values: YES, NO
Default: NO
A boolean value to indicate whether this is a primary source or not (only used in EDW).
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Name: TARGET_FILTER_FOR_DELETE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
Name: TARGET_FILTER_FOR_UPDATE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
Properties for NAME_AND_ADDRESS OPERATOR:
Name: ADDRESS_LINE_1
Type: STRING
Valid Values: N/A
Default: N/A
Address line 1
Name: ADDRESS_LINE_2
Type: STRING
Valid Values: N/A
Default: N/A
Address line 2
Name: ADDRESS_LINE_3
Type: STRING
Valid Values: N/A
Default: N/A
Address line 3
Name: ADDRESS_LINE_4
Type: STRING
Valid Values: N/A
Default: N/A
Address line 4
Name: DUAL_ADDRESS_ASSIGNMENT
Type: STRING
Valid Values: NA_DUALADDR_STREET, NA_DUALADDR_POBOX, NA_DUALADDR_CLOSESTTOLASTLINE
Default: 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.
Name: GENERATE_CASS_REPORT
Type: STRING
Valid Values: NA_YES, NA_NO
Default: 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.
Name: LIST_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The list name is optional and provides a reference for tracking multiple CASS reports.
Name: PARSING_TYPE
Type: STRING
Valid Values: NA_NAMEONLY, NA_ADDRESSONLY, NA_NAMEANDADDRESS
Default: NA_NAMEANDADDRESS
Select a name-address parsing type to be performed on the input data
Name: PRIMARY_COUNTRY
Type: STRING
Valid Values: NA_ARG, NA_AUS, NA_BEL, NA_BRA, NA_CAN, NA_CHL, NA_COL, NA_DNK, NA_FRA, NA_DEU, NA_HKG, NA_IND, NA_IRL, NA_ITA, NA_MEX, NA_MYS, NA_NLD, NA_NZL, NA_PER, NA_PHL, NA_PRT, NA_SGP, NA_ZAF, NA_ESP, NA_SWE, NA_CHE, NA_ARE, NA_GBR, NA_USA, NA_VEN
Default: 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.
Name: PROCESSOR_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The processor name is the name of the organization submitting the CASS report.
Properties for OUTPUT_PARAMETER OPERATOR:
Properties for PIVOT OPERATOR:
Name: PIVOT_GROUP_SIZE
Type: NUMBER
Valid Values: 1 - 1000
Default: 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.
Properties for POSTMAPPING_PROCESS OPERATOR:
Name: FUNCTION_CALL
Type: STRING
Valid Values: N/A
Default: N/A
Expression template for procedure call
Name: FUNCTION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Name of the transformation to be called.
Name: POSTMAPPING_PROCESS_RUN_CONDITION
Type: STRING
Valid Values: ALWAYS, ON_SUCCESS, ON_ERROR, ON_WARNING
Default: ON_SUCCESS
Indicates under what condition of the mapping the post-mapping process will be run.
Name: ROWBASED_ONLY
Type: BOOLEAN
Valid Values: true, false
Default: N/A
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.
Properties for PREMAPPING_PROCESS OPERATOR:
Name: FUNCTION_CALL
Type: STRING
Valid Values: N/A
Default: N/A
Expression template for procedure call
Name: FUNCTION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Name of the transformation to be called.
Name: MAPPING_RUN_CONDITION
Type: STRING
Valid Values: ALWAYS, ON_SUCCESS, ON_ERROR
Default: ON_SUCCESS
Indicates under what condition of the pre-mapping process the mapping will be run.
Name: ROWBASED_ONLY
Type: BOOLEAN
Valid Values: true, false
Default: N/A
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.
Properties for SEQUENCE OPERATOR:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Properties for SET_OPERATION OPERATOR:
Name: SET_OPERATION
Type: STRING
Valid Values: UNION, UNIONALL, INTERSECT, MINUS
Default: UNION
Specifies the set operation that is to be performed by this operator.
Properties for SORTER OPERATOR:
Name: ORDER_BY_CLAUSE
Type: STRING
Valid Values: N/A
Default: N/A
The Order By Clause
Properties for TABLE OPERATOR:
Name: ADVANCED_MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: 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.
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Database file name to allocate extents from
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: DATA_COLLECTION_FREQUENCY
Type: STRING
Valid Values: UNKNOWN, YEAR, QUARTER, MONTH, DAY, HOUR, MINUTE
Default: UNKNOWN
New Data Granularity
Name: DIRECT
Type: BOOLEAN
Valid Values: true, false
Default: false
Directly swap source into target as a partition without first creating a staging table.
Name: ENABLE_CONSTRAINTS
Type: BOOLEAN
Valid Values: true, false
Default: true
Enable Constraints
Name: EXCEPTIONS_TABLE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Exceptions Table Name
Name: EXTRACTION_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when extracting from this table using SQL
Name: LOADING_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when loading into this table using SQL
Name: LOADING_TYPE
Type: STRING
Valid Values: INSERT, UPDATE, INSERT_UPDATE, UPDATE_INSERT, DELETE, NONE, TRUNCATE_INSERT, DELETE_INSERT, CHECK_INSERT
Default: INSERT
The loading operation to be performed when this is a target.
Name: MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: YES
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.
Name: PARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Partition Name
Name: PEL_ENABLED
Type: BOOLEAN
Valid Values: true, false
Default: false
PEL Enabled
Name: PRIMARY_SOURCE
Type: STRING
Valid Values: YES, NO
Default: NO
A boolean value to indicate whether this is a primary source or not (only used in EDW).
Name: RECORDS_TO_SKIP
Type: NUMBER
Valid Values: N/A
Default: N/A
Number of records to skip
Name: REPLACE_DATA
Type: BOOLEAN
Valid Values: true, false
Default: false
Replace existing data in target partition if there is any.
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Name: SINGLEROW
Type: BOOLEAN
Valid Values: true, false
Default: false
Singlerow
Name: SORTED_INDEXES_CLAUSE
Type: STRING
Valid Values: N/A
Default: N/A
Sorted Indexes Clause
Name: SUBPARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Subpartition Name
Name: TARGET_FILTER_FOR_DELETE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
Name: TARGET_FILTER_FOR_UPDATE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
Name: TRAILING_NULLCOLS
Type: BOOLEAN
Valid Values: true, false
Default: false
Trailing Nullcols
Properties for TABLE_FUNCTION OPERATOR:
Name: TABLE_FUNCTION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name of the Table Function
Properties for TRANSFORMATION OPERATOR:
Name: FUNCTION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Name of the transformation to be called.
Name: ROWBASED_ONLY
Type: BOOLEAN
Valid Values: true, false
Default: N/A
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.
Properties for VIEW OPERATOR:
Name: ADVANCED_MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: 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.
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DATABASE_FILE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Database file name to allocate extents from
Name: DATABASE_LINK
Type: STRING
Valid Values: N/A
Default: N/A
The database link used to access this entity during mapping.
Name: EXTRACTION_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when extracting from this table using SQL
Name: LOADING_HINT
Type: STRING
Valid Values: N/A
Default: N/A
Hint used when loading into this table using SQL
Name: LOADING_TYPE
Type: STRING
Valid Values: INSERT, UPDATE, INSERT_UPDATE, UPDATE_INSERT, DELETE, NONE, TRUNCATE_INSERT, DELETE_INSERT, CHECK_INSERT
Default: INSERT
The loading operation to be performed when this is a target.
Name: MATCH_BY_CONSTRAINT
Type: STRING
Valid Values: N/A
Default: YES
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.
Name: PARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Partition Name
Name: PRIMARY_SOURCE
Type: STRING
Valid Values: YES, NO
Default: NO
A boolean value to indicate whether this is a primary source or not (only used in EDW).
Name: RECORDS_TO_SKIP
Type: NUMBER
Valid Values: N/A
Default: N/A
Number of records to skip
Name: SCHEMA
Type: STRING
Valid Values: N/A
Default: N/A
Schema
Name: SINGLEROW
Type: BOOLEAN
Valid Values: true, false
Default: false
Singlerow
Name: SORTED_INDEXES_CLAUSE
Type: STRING
Valid Values: N/A
Default: N/A
Sorted Indexes Clause
Name: SUBPARTITION_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Subpartition Name
Name: TARGET_FILTER_FOR_DELETE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the delete loading operation.
Name: TARGET_FILTER_FOR_UPDATE
Type: STRING
Valid Values: N/A
Default: N/A
A condition on the rows in the target and if evaluated to true, that row will participate in the update loading operation.
Name: TRAILING_NULLCOLS
Type: BOOLEAN
Valid Values: true, false
Default: false
Trailing Nullcols
Properties for CUBE,DIMENSION,KEY_LOOKUP,MATERIALIZED_VIEW,TABLE,VIEW OPERATOR KEYS_READONLY CHILD:
Name: KEY_COLUMNS
Type: STRING
Valid Values: N/A
Default: N/A
Local columns that define this key (Comma separated if more than one).
Name: KEY_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Name of the primary, foreign or unique key (primary, foreign, or unique).
Name: KEY_TYPE
Type: STRING
Valid Values: N/A
Default: UNIQUE
Type of key - primary, foreign or unique.
Name: REFERENCED_KEYS
Type: STRING
Valid Values: N/A
Default: N/A
If the key is a foreign key, this will contain the key or keys used of the referenced object.
Properties for MATCHMERGE OPERATOR MATCH_RULES CHILD:
Name: ADDRESS_ADDRESS_LINE_SIMILARITY_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
Similarity score for address line in Address Match Rule.
Name: ADDRESS_ALLOW_DIFFERING_SECONDARY_ADDRESSES
Type: BOOLEAN
Valid Values: true, false
Default: false
Allow differing secondary addresses to match in Address Match Rule.
Name: ADDRESS_LAST_LINE_SIMILARITY_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
Similarity score for last line in Address Match Rule.
Name: ADDRESS_MATCH_ON_ADDRESS_LINE_SIMILARITY
Type: BOOLEAN
Valid Values: true, false
Default: false
Check address line similarity in Address Match Rule.
Name: ADDRESS_MATCH_ON_BLANK_SECONDARY_ADDRESSES
Type: BOOLEAN
Valid Values: true, false
Default: false
Match on blank secondary address in Address Match Rule.
Name: ADDRESS_MATCH_ON_LAST_LINE_SIMILARITY
Type: BOOLEAN
Valid Values: true, false
Default: false
Check last line similarity in Address Match Rule.
Name: ADDRESS_MATCH_ON_STREET_OR_PO_BOX
Type: BOOLEAN
Valid Values: true, false
Default: false
Match on Street or Post Office (PO) Box in Address Match Rule.
Name: CUSTOM_RULE
Type: STRING
Valid Values: N/A
Default: N/A
Custom Merge Rule
Name: DESCRIPTION
Type: STRING
Valid Values: N/A
Default: N/A
Description of match rule.
Name: FIRM_CROSS_MATCH_FIRM1_AND_FIRM2
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a firm match rule, should Warehouse Builder cross match firm 1 and firm 2?
Name: FIRM_MATCH_ON_ABBREVIATIONS
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a firm match rule, should Warehouse Builder match on abbreviations?
Name: FIRM_MATCH_ON_ACRONYMS
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a firm match rule, should Warehouse Builder match on acronyms?
Name: FIRM_MATCH_ON_PARTIAL_NAMES
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a firm match rule, should Warehouse Builder match on partial names?
Name: FIRM_MATCH_ON_SIMILARITY
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a firm match rule, should Warehouse Builder check firm similarity?
Name: FIRM_SIMILARITY_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
Similarity score for firm in Firm Match Rule.
Name: FIRM_STRIP_NOISE_WORDS
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a firm match rule, should Warehouse Builder strip noise words?
Name: PERSON_DETECT_SWITCHED_NAME_ORDER
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person rule, should Warehouse Builder detect the switched name order.
Name: PERSON_FN_DETECT_COMPOUND_NAME
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder detect compound names?
Name: PERSON_FN_MATCH_ON_INITIALS
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on initials.
Name: PERSON_FN_MATCH_ON_SIMILARITY
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on first name similarity?
Name: PERSON_FN_MATCH_ON_SOUNDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on first name soundex?
Name: PERSON_FN_MATCH_ON_SUBSTRINGS
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on first name substrings?
Name: PERSON_FN_MRS_MATCH
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder detect MRS? (For example, should Mrs John Smith match Mrs Smith)
Name: PERSON_FN_SIMILARITY_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
If matching in first name similarity, what is the similarity score?
Name: PERSON_LN_DETECT_MISSING_HYPHEN
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder detect missing hyphens?
Name: PERSON_LN_MATCH_HYPHENATED_NAMES
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on hyphenated last name?
Name: PERSON_LN_MATCH_ON_SIMILARITY
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on last name similarity?
Name: PERSON_LN_MATCH_ON_SOUNDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on last name soundex?
Name: PERSON_LN_SIMILARITY_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
If Warehouse Builder is matching on last name similarity, what is the similarity score?
Name: PERSON_MN_MATCH_ON_INITIALS
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on middle name initials?
Name: PERSON_MN_MATCH_ON_SIMILARITY
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on middle name similarity?
Name: PERSON_MN_MATCH_ON_SOUNDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on middle name soundex?
Name: PERSON_MN_MATCH_ON_SUBSTRINGS
Type: BOOLEAN
Valid Values: true, false
Default: false
If this is a person match rule, should Warehouse Builder match on middle name substrings?
Name: PERSON_MN_SIMILARITY_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
If Warehouse Builder is matching on middle name similarity, what is the similarity score?
Name: TOTAL_WEIGHT_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
If this is a weight rule, the sum of all weights must be equal to or greater than this score for the records to pass the weght rule.
Name: TYPE
Type: STRING
Valid Values: MM_TRUE, MM_FALSE, MM_WEIGHT, MM_CONDITIONAL, MM_CUSTOM, MM_PERSON, MM_FIRM, MM_ADDRESS
Default: MM_TRUE
What type of match rule is this? Possible types are: MM_TRUE, MM_FALSE, MM_WEIGHT, MM_CONDITIONAL, MM_CUSTOM, MM_PERSON, MM_FIRM, MM_ADDRESS
Name: USAGE
Type: STRING
Valid Values: MM_ACTIVE, MM_PASSIVE
Default: MM_ACTIVE
Is this an active or passive rule? Possible usages are: MM_ACTIVE, MM_PASSIVE.
Properties for MATCHMERGE OPERATOR MERGE_RULES CHILD:
Name: ATTRIBUTE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Merge Attribute
Name: COPY_ATTRIBUTE
Type: STRING
Valid Values: N/A
Default: N/A
Copy this merged attribute to merge rule target attribute.
Name: CUSTOM_TEXT
Type: STRING
Valid Values: N/A
Default: N/A
Implementation text for custom merge rule. Include "BEGIN and END statements.
Name: DESCRIPTION
Type: STRING
Valid Values: N/A
Default: N/A
Description
Name: MATCH_ID_SEQUENCE_MODULE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Physical sequence module name for match id merge rule. This sequence will be used to generate the match id.
Name: MATCH_ID_SEQUENCE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Physical sequence name for match id merge rule. This sequence will be used to generate the match id.
Name: MIN_MAX_ATTRIBUTE
Type: STRING
Valid Values: N/A
Default: N/A
Selecting attribute for min/max merge rule
Name: MIN_MAX_TYPE
Type: STRING
Valid Values: MM_MIN, MM_MAX, MM_SHORTEST, MM_LONGEST
Default: MM_MAX
Select record where attribute is min,max, shortest, longest. Possible values are MM_MIN, MM_MAX, MM_SHORTEST, MM_LONGEST.
Name: SEQUENCE_MODULE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Physical sequence module name for sequence merge rule.
Name: SEQUENCE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Physical sequence name for sequence merge rule.
Name: TYPE
Type: STRING
Valid Values: MM_ANY, MM_MATCH_ID, MM_RANK, MM_SEQUENCE, MM_MIN_MAX, MM_COPY, MM_CUSTOM, MM_RECORD_ANY, MM_RECORD_RANK, MM_RECORD_MIN_MAX, MM_RECORD_CUSTOM
Default: MM_ANY
Merge Rule Type. Possible values are:MM_ANY,MM_MATCH_ID,MM_RANK,MM_SEQUENCE,MM_MIN_MAX,MM_COPY,MM_CUSTOM,MM_RECORD_ANY,MM_RECORD_RANK,MM_RECORD_MIN_MAX,MM_RECORD_CUSTOM.
Properties for MATCHMERGE OPERATOR MATCH_RULES CHILD ADDRESS_ROLES CHILD:
Name: ATTRIBUTE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
What is the attribute for this role?
Name: TYPE
Type: STRING
Valid Values: MM_PRIMARY_ADDR, MM_UNIT_NUM, MM_PO_BOX, MM_DUAL_PRIMARY_ADDR, MM_DUAL_UNIT_NUM, MM_DUAL_PO_BOX, MM_CITY, MM_STATE, MM_POSTAL_CODE, MM_IS_FOUND
Default: MM_PRIMARY_ADDR
What role is this attribute? Possible values are: MM_PRIMARY_ADDR, MM_UNIT_NUM, MM_PO_BOX, MM_DUAL_PRIMARY_ADDR, MM_DUAL_UNIT_NUM, MM_DUAL_PO_BOX, MM_CITY, MM_STATE, MM_POSTAL_CODE, MM_IS_FOUND.
Properties for MATCHMERGE OPERATOR MATCH_RULES CHILD CONDITIONS CHILD:
Name: ALGORITHM
Type: STRING
Valid Values: MM_EXACT, MM_STD_EXACT, MM_SOUNDEX, MM_SIMILARITY, MM_STD_SIMILARITY, MM_PARTIAL_NAME, MM_ABBREVIATION, MM_ACRONYM
Default: MM_EXACT
Algorithm of this condition. Possible values are: MM_EXACT, MM_STD_EXACT, MM_SOUNDEX, MM_SIMILARITY, MM_STD_SIMILARITY, MM_PARTIAL_NAME, MM_ABBREVIATION, MM_ACRONYM.
Name: ATTRIBUTE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
To which attribute does this condition apply?
Name: BLANK_MATCHING
Type: STRING
Valid Values: MM_MATCH_BOTH_BLANK, MM_MATCH_EITHER_BLANK, MM_NO_MATCH_IF_BLANK
Default: MM_MATCH_BOTH_BLANK
How do you want blanks to be handled? Possible values are: MM_MATCH_BOTH_BLANK, MM_MATCH_EITHER_BLANK, MM_NO_MATCH_IF_BLANK.
Name: SIMILARITY_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
If this is a similarity condition, what score must the similarity equal or exceed for records to meet the condition?
Properties for MATCHMERGE OPERATOR MATCH_RULES CHILD FIRM_ROLES CHILD:
Name: ATTRIBUTE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
What is the attribute for this role?
Name: TYPE
Type: STRING
Valid Values: MM_FIRM1, MM_FIRM2
Default: MM_FIRM1
What role is this attribute? Possible values are: MM_FIRM1,MM_FIRM2.
Properties for MATCHMERGE OPERATOR MATCH_RULES CHILD PERSON_ROLES CHILD:
Name: ATTRIBUTE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
What is the attribute for this role.
Name: TYPE
Type: STRING
Valid Values: MM_PRENAME, MM_FIRST_NAME_STD, MM_MIDDLE_NAME_STD, MM_MIDDLE_NAME_2_STD, MM_MIDDLE_NAME_3_STD, MM_LAST_NAME, MM_MATURITY_POST_NAME
Default: MM_PRENAME
What role is this attribute? Possible values are: MM_PRENAME, MM_FIRST_NAME_STD, MM_MIDDLE_NAME_STD, MM_MIDDLE_NAME_2_STD, MM_MIDDLE_NAME_3_STD, MM_LAST_NAME, MM_MATURITY_POST_NAME.
Properties for MATCHMERGE OPERATOR MATCH_RULES CHILD WEIGHTS CHILD:
Name: BLANK_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
Score if either attribute is blank
Name: WEIGHT_ATTRIBUTE
Type: STRING
Valid Values: N/A
Default: N/A
Attribute
Name: WEIGHT_SCORE
Type: NUMBER
Valid Values: N/A
Default: N/A
Score used for this weight if the attributes in the two match records are identical. Similarity will be used to generate this score.
Properties for MATCHMERGE OPERATOR MERGE_RULES CHILD ATTRIBUTES CHILD:
Name: ATTRIBUTE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
Record merge rule attribute
Properties for MATCHMERGE OPERATOR MERGE_RULES CHILD RANK_RULES CHILD:
Name: EXPRESSION
Type: STRING
Valid Values: N/A
Default: N/A
Rank expression.
Properties for FLAT_FILE OPERATOR INOUT GROUP:
Name: RECORD_TYPE_VALUES
Type: STRING
Valid Values: N/A
Default: N/A
Record Type Values.
Properties for JOINER OPERATOR INPUT GROUP:
Properties for PIVOT OPERATOR OUTPUT GROUP:
Name: ROW_LOCATOR
Type: STRING
Valid Values: N/A
Default: N/A
An expression indicating which attribute within the output group is the row locator.
Properties for SPLITTER OPERATOR OUTPUT GROUP:
Name: SPLIT_CONDITION
Type: STRING
Valid Values: N/A
Default: N/A
Condition that defines when to perform the attribute maps for the attributes in this group.
Properties for TABLE_FUNCTION OPERATOR INPUT GROUP:
Name: INPUT_PARAMETER_TYPE
Type: STRING
Valid Values: REF_CURSOR, SCALAR
Default: REF_CURSOR
This property specifies whether the input parameter is a scalar or a ref cursor type
Name: PARAMETER_POSITION
Type: NUMBER
Valid Values: N/A
Default: N/A
The position of the argument in the table function signature corresponding to this parameter group
Properties for TABLE_FUNCTION OPERATOR OUTPUT GROUP:
Name: RETURN_TABLE_OF_SCALAR
Type: BOOLEAN
Valid Values: true, false
Default: false
This property specifies whether the return of the table function is a TABLE of SCALAR or not.
Properties for UNPIVOT OPERATOR INPUT GROUP:
Name: ROW_LOCATOR
Type: STRING
Valid Values: N/A
Default: N/A
An expression indicating which attribute within the input group is the row locator.
Name: ROW_LOCATOR_VALUES
Type: STRING
Valid Values: N/A
Default: NULL, NULL
A comma-separated expressions that gives the possible values of the row locator within a unpivot group.
Properties for ADVANCED_QUEUE OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Properties for CUBE OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: LOAD_COLUMN_WHEN_INSERTING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the insert load operation.
Name: LOAD_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the update load operation.
Name: MATCH_COLUMN_WHEN_DELETING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: MATCH_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: UPDATE_OPERATION
Type: STRING
Valid Values: =, +=, -=, =-, =||, ||=
Default: =
The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.
Properties for DIMENSION OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: LOAD_COLUMN_WHEN_INSERTING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the insert load operation.
Name: LOAD_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the update load operation.
Name: MATCH_COLUMN_WHEN_DELETING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: MATCH_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: UPDATE_OPERATION
Type: STRING
Valid Values: =, +=, -=, =-, =||, ||=
Default: =
The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.
Properties for EXTERNAL_TABLE OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Properties for INPUT_PARAMETER OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: DEFAULT_VALUE
Type: STRING
Valid Values: N/A
Default: N/A
The default value applies when the map is not given a value for this attribute. The value can be specified only by the calling program.
Properties for KEY_LOOKUP OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DEFAULT_VALUE
Type: STRING
Valid Values: N/A
Default: N/A
The default value used for this attribute if no key lookup table row exists for a given input row.
Properties for MATCHMERGE OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: MERGE_ATTR
Type: STRING
Valid Values: N/A
Default: N/A
Related merge attribute
Properties for MATERIALIZED_VIEW OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: LOAD_COLUMN_WHEN_INSERTING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the insert load operation.
Name: LOAD_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the update load operation.
Name: MATCH_COLUMN_WHEN_DELETING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: MATCH_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: UPDATE_OPERATION
Type: STRING
Valid Values: =, +=, -=, =-, =||, ||=
Default: =
The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.
Properties for NAME_AND_ADDRESS OPERATOR INPUT GROUP ATTRIBUTE:
Name: INPUT_ROLE
Type: STRING
Valid Values: NA_NONE, NA_FIRSTNAME, NA_MIDDLENAME, NA_MIDDLENAME2, NA_MIDDLENAME3, NA_LASTNAME, NA_FIRSTPARTNAME, NA_LASTPARTNAME, NA_PRENAME, NA_POSTNAME, NA_PERSON, NA_PERSON2, NA_PERSON3, NA_FIRMNAME, NA_PRIMARYADDRESS, NA_SECONDARYADDRESS, NA_ADDRESS, NA_ADDRESS2, NA_NEIGHBORHOOD, NA_LASTLINE, NA_CITY, NA_STATE, NA_POSTALCODE, NA_COUNTRYNAME, NA_COUNTRYCODE, NA_LINE1, NA_LINE2, NA_LINE3, NA_LINE4, NA_LINE5, NA_LINE6, NA_LINE7, NA_LINE8, NA_LINE9, NA_LINE10
Default: NA_NONE
Assigns a name-address input role to the selected input attribute
Properties for NAME_AND_ADDRESS OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: ADDRESS_TYPE
Type: STRING
Valid Values: NA_ADDRTYPE_NORMAL, NA_ADDRTYPE_DUAL
Default: 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.
Name: INSTANCE
Type: STRING
Valid Values: NA_INSTANCE_FIRST, NA_INSTANCE_SECOND, NA_INSTANCE_THIRD, NA_INSTANCE_FOURTH, NA_INSTANCE_FIFTH, NA_INSTANCE_SIXTH
Default: 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.
Name: OUTPUT_COMPONENT
Type: STRING
Valid Values: NA_NONE, NA_PRENAME, NA_FIRSTNAMESTD, NA_MIDDLENAMESTD, NA_MIDDLENAME2STD, NA_MIDDLENAME3STD, NA_POSTNAME, NA_OTHERPOSTNAME, NA_NAMEDESIGNATOR, NA_RELATIONSHIP, NA_PERSON, NA_FIRSTNAME, NA_MIDDLENAME, NA_MIDDLENAME2, NA_MIDDLENAME3, NA_LASTNAME, NA_GENDER, NA_PERSONCOUNT, NA_FIRMNAME, NA_FIRMCOUNT, NA_ADDRESS, NA_PRIMARYADDRESS, NA_STREETNUMBER, NA_PREDIRECTIONAL, NA_STREETNAME, NA_STREETTYPE, NA_POSTDIRECTIONAL, NA_SECONDARYADDRESS, NA_UNITDESIGNATOR, NA_UNITNUMBER, NA_BOXNAME, NA_BOXNUMBER, NA_ROUTENAME, NA_ROUTENUMBER, NA_BUILDINGNAME, NA_COMPLEX, NA_MISCADDRESS, NA_LASTLINE, NA_NEIGHBORHOOD, NA_CITY, NA_STATE, NA_POSTALCODE, NA_POSTALCODEFORMATTED, NA_DELIVERYPOINT, NA_COUNTRYCODE, NA_COUNTRYCODE3, NA_COUNTRYNAME, NA_ISGOODGROUP, NA_ISPARSED, NA_PARSESTATUS, NA_PARSESTATUSDESC, NA_ISGOODNAME, NA_NAMEWARNING, NA_ISGOODADDRESS, NA_ISFOUND, NA_CITYMATCH, NA_STREETNAMEMATCH, NA_STREETNUMBERMATCH, NA_STREETCOMPMATCH, NA_NONAMBIGUOUSMATCH, NA_CITYWARNING, NA_STREETWARNING, NA_ISADDRESSVERIFIABLE, NA_ADDRESSCORRECTED, NA_POSTALCODECORRECTED, NA_CITYCORRECTED, NA_STREETCORRECTED, NA_STREETCOMPCORRECTED, NA_ADDRESSTYPE, NA_PARSINGCOUNTRY, NA_INSTALLATIONTYPE, NA_INSTALLATIONNAME, NA_DELIVERYOFFICECODE, NA_DELIVERYBEATCODE, NA_ADDRESS2, NA_LOCALITYCODE, NA_LOCALITYNAME, NA_COUNTYNAME, NA_ZIP5, NA_ZIP4, NA_URBANIZATIONNAME, NA_LACS, NA_CART, NA_CHECKDIGIT, NA_MSA, NA_MCD, NA_LATITUDE, NA_LONGITUDE, NA_FIPSCOUNTY, NA_FIPS, NA_CENSUSID
Default: NA_NONE
Assigns a Name and Address output component to the selected output attribute.
Properties for PIVOT OPERATOR INPUT GROUP ATTRIBUTE:
Name: GROUP_KEY
Type: BOOLEAN
Valid Values: true, false
Default: false
A boolean value to indicate whether this input attribute is a part of the pivot group key.
Properties for PIVOT OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: GROUP_KEY
Type: BOOLEAN
Valid Values: true, false
Default: false
A boolean value to indicate whether this output attribute is a part of the pivot group key, which obtains its value from its corresponding input attribute.
Name: PIVOT_EXPRESSION
Type: STRING
Valid Values: N/A
Default: N/A
A comma-separated expression that gives the input attribute to be used for each output row in the pivot group.
Properties for POSTMAPPING_PROCESS OPERATOR INPUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DEFAULT_VALUE
Type: STRING
Valid Values: N/A
Default: N/A
The Default Value for the function input parameter
Name: IS_OPTIONAL
Type: BOOLEAN
Valid Values: true, false
Default: N/A
If true, the input is not required to be connected
Properties for POSTMAPPING_PROCESS OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: FUNCTION_RETURN
Type: BOOLEAN
Valid Values: true, false
Default: N/A
Specifies whether this output is the return value of this function
Properties for PREMAPPING_PROCESS OPERATOR INPUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DEFAULT_VALUE
Type: STRING
Valid Values: N/A
Default: N/A
The Default Value for the function input parameter
Name: IS_OPTIONAL
Type: BOOLEAN
Valid Values: true, false
Default: N/A
If true, the input is not required to be connected
Properties for PREMAPPING_PROCESS OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: FUNCTION_RETURN
Type: BOOLEAN
Valid Values: true, false
Default: N/A
Specifies whether this output is the return value of this function
Properties for TABLE OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: LOAD_COLUMN_WHEN_INSERTING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the insert load operation.
Name: LOAD_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the update load operation.
Name: MATCH_COLUMN_WHEN_DELETING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: MATCH_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: UPDATE_OPERATION
Type: STRING
Valid Values: =, +=, -=, =-, =||, ||=
Default: =
The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.
Properties for TABLE_FUNCTION OPERATOR INPUT GROUP ATTRIBUTE:
Name: PARAMETER_POSITION
Type: NUMBER
Valid Values: N/A
Default: N/A
The position of the argument in the table function signature corresponding to this parmater
Properties for TABLE_FUNCTION OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: TYPE_ATTRIBUTE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
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.
Properties for TRANSFORMATION OPERATOR INPUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: DEFAULT_VALUE
Type: STRING
Valid Values: N/A
Default: N/A
The Default Value for the function input parameter
Name: IS_OPTIONAL
Type: BOOLEAN
Valid Values: true, false
Default: N/A
If true, the input is not required to be connected
Properties for TRANSFORMATION OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: FUNCTION_RETURN
Type: BOOLEAN
Valid Values: true, false
Default: N/A
Specifies whether this output is the return value of this function
Properties for TRANSFORMATION OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Properties for UNPIVOT OPERATOR INPUT GROUP ATTRIBUTE:
Name: GROUP_KEY
Type: BOOLEAN
Valid Values: true, false
Default: false
A boolean value to indicate whether this input attribute is a part of the unpivot group key.
Properties for UNPIVOT OPERATOR OUTPUT GROUP ATTRIBUTE:
Name: GROUP_KEY
Type: BOOLEAN
Valid Values: true, false
Default: 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.
Name: MATCHING_ROW
Type: NUMBER
Valid Values: 1 - 1000
Default: 1
An positive integer to indicate from which row within the unpivot group this output attribute obtains its data.
Name: UNPIVOT_EXPRESSION
Type: STRING
Valid Values: N/A
Default: NULL
An expression that gives the input attribute to be used as the output of this attribute.
Properties for VIEW OPERATOR INOUT GROUP ATTRIBUTE:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The name to be used by the code generator to identify this item. By default it is the same physical name as the item.
Name: LOAD_COLUMN_WHEN_INSERTING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the insert load operation.
Name: LOAD_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
A boolean value to indicate whether this attribute will particiate in the update load operation.
Name: MATCH_COLUMN_WHEN_DELETING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: MATCH_COLUMN_WHEN_UPDATING_ROW
Type: STRING
Valid Values: YES, NO
Default: YES
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.
Name: UPDATE_OPERATION
Type: STRING
Valid Values: =, +=, -=, =-, =||, ||=
Default: =
The computation to be performed on this attribute between the incoming data and the existing data on the target during the update load operation.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
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.
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.
OMBCREATE MAPPING 'MAP1'
OMBCREATE MAPPING 'MAP1'
SET PROPERTIES (business_name, description)
VALUES ('My map', 'Map to load customer look up table')
ADD TABLE OPERATOR 'CUST_SRC'
BOUND TO TABLE '../SRC_MODULE/CUST_SRC'
ADD TABLE OPERATOR 'CUST_LOOK_UP'
ADD CONNECTION FROM GROUP 'INOUTGRP1' OF OPERATOR 'CUST_SRC'
TO GROUP 'INOUTGRP1' OF OPERATOR 'CUST_LOOK_UP'
OMBCREATE, OMBALTER MAPPING, OMBRETRIEVE MAPPING, OMBDROP MAPPING
OMBCREATE MATERIALIZED_VIEW - To create a materialized view.
In the context of an Oracle Module.
createMaterializedViewCommand = OMBCREATE ( MATERIALIZED_VIEW "QUOTED_STRING" [ SET "setPropertiesClause" ] [ "addViewSCOClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addViewSCOClause = ADD ( "addColumnClause" | "addViewConstraintClause" | "addConfigurationClause" ) [ "addViewSCOClause" ];propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };addColumnClause = COLUMN "QUOTED_STRING" [ SET "setPropertiesClause" ];addViewConstraintClause = "addUkPkClause" | "addFkClause";addConfigurationClause = "addIndexClause" | "addPartitionClause" | "addPartitionKeyClause" | "addIndexColumnClause";propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );addUkPkClause = ( UNIQUE_KEY | PRIMARY_KEY ) "QUOTED_STRING" [ SET "setUkPkPropertiesAndReferencesColumnsClauses" ];addFkClause = FOREIGN_KEY "QUOTED_STRING" [ SET "setFkSubClauses" ];addIndexClause = INDEX "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addPartitionClause = PARTITION "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addPartitionKeyClause = PARTITION_KEY "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addIndexColumnClause = INDEX_COLUMN "QUOTED_STRING" OF INDEX "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];setUkPkPropertiesAndReferencesColumnsClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "constraintColumnReferencesClause" ] | ( REF | REFERENCE ) "constraintColumnReferencesClause";setFkSubClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "setFkReferencesClauses" ] | ( REF | REFERENCE ) "setFkReferencesClauses";setSCOConfigurationPropertiesClauses = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";constraintColumnReferencesClause = COLUMNS "(" "quotedNameList" ")";setFkReferencesClauses = "constraintColumnReferencesClause" [ SET ( REF | REFERENCE ) "constraintUkReferencesClause" ] | "constraintUkReferencesClause" [ SET ( REF | REFERENCE ) "constraintColumnReferencesClause" ];quotedNameList = "QUOTED_STRING" { "," "QUOTED_STRING" };constraintUkReferencesClause = ( UNIQUE_KEY | PRIMARY_KEY ) "QUOTED_STRING" [ OF ( TABLE | VIEW ) "QUOTED_STRING" ];
createMaterializedViewCommand
This command creates a materialized view.
QUOTED_STRING
Specify the name of the materialized view to be created.
setPropertiesClause
Used to set properties (core, logical, physical, user-defined) for tables, columns, unique keys, foreign keys, primary keys, and check constraints. Valid properties are shown below:
Basic properties for VIEW, MATERIALIZED_VIEW:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the View, MaterializedView
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the View, MaterializedView
Name: VIEW_QUERY
Type: STRING(4000)
Valid Values: N/A
Default: ''
Sets the query definition in View and MaterializedView.
Name: UOID
Type: STRING
Valid Values: N/A
Default: N/A
Basic properties for INDEX, PARTITION, PARTITION_KEY, INDEX_COLUMN:
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Index, Partition, PartitionKey, IndexColumn in a MaterializedView.
Properties for MATERIALIZED_VIEW:
Name: BASE_TABLES
Type: STRING
Valid Values: N/A
Default: ''
Comma separated list of base tables.
Name: BUILD
Type: STRING
Valid Values: DEFERRED, IMMEDIATE
Default: IMMEDIATE
Immediate : populates the view when it is created. Deferred : delays population until the next refresh operation.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: HASH_PARTITION_TABLESPACE_LIST
Type: STRING
Valid Values: N/A
Default: ''
A comma separated list of tablespaces to use for [sub]partition storage.
Name: HASH_SUBPARTITION_NUMBER
Type: NUMBER
Valid Values: 2 - 63999
Default: 2
Hash SubPartition Number
Name: LOGGING_MODE
Type: STRING
Valid Values: NOLOGGING, LOGGING
Default: LOGGING
Recovery requirements for a data warehouse : Logging or not logging to Redo Log File.
Name: PARALLEL_ACCESS_MODE
Type: STRING
Valid Values: NOPARALLEL, PARALLEL
Default: PARALLEL
Enables or disables parallel processing when the table is created. Also enables or disables parallel processing or access.
Name: QUERY_REWRITE
Type: STRING
Valid Values: DISABLE, ENABLE
Default: ENABLE
Enable marks the View eligible for query rewrite and disable marks the View ineligible for query rewrite
Name: REFRESH
Type: STRING
Valid Values: COMPLETE, FAST, ON_COMMIT, ON_DEMAND, FORCE
Default: COMPLETE
Complete : specifies the complete refresh method implemented by executing the query of the view. Fast : specifies the incremental refresh method which refreshes the view according to changes that have occurred to the master tables. Force : specifies that when a refresh occurs, Oracle performs a fast refresh if possible or a complete refresh otherwise.
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Use the Tablespace parameter to specify the name of tablespace.
Properties for UNIQUE_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for FOREIGN_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for CHECK_CONSTRAINT:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for INDEX:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: INDEX_TYPE
Type: STRING
Valid Values: BITMAP, UNIQUE, NO_INDEX
Default: UNIQUE
The types of Indexes created on Dimension are BITMAP, UNIQUE or a non-specific index.
Name: LOCAL_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
A local index is constructed so that it reflects the structure of the underlying table. It is equipartitioned with the underlying table, meaning that it is partitioned on the same columns as the underlying table, creates the same number of partitions or subpartitions, and gives them the same partition bounds as corresponding partitions of the underlying table.
Name: LOGGING_MODE
Type: STRING
Valid Values: NOLOGGING, LOGGING
Default: LOGGING
Recovery requirements for a data warehouse : Logging or not logging to Redo Log File.
Name: PARALLEL_ACCESS_MODE
Type: STRING
Valid Values: NOPARALLEL, PARALLEL
Default: PARALLEL
Enables or disables parallel processing when the table is created. Also enables or disables parallel processing or access.
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Use the Tablespace parameter to specify the name of tablespace.
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for PARTITION:
Name: DATE_LESS_THAN
Type: STRING
Valid Values: N/A
Default: TO_DATE('01-JAN-1999', 'DD-MON-YYYY')
Value that represents upper bound of partition stored in warehouse key column for the Days Dimension.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: EMPTY_STRING
Use the Tablespace parameter to specify the name of tablespace.
Name: VALUES_LESS_THAN
Type: STRING
Valid Values: N/A
Default: TO_DATE('01-JAN-1999', 'DD-MON-YYYY')
Noninclusive upper bound for the current partition. Type a comma separated list in the same order as the columns in range partitioned key.
Name: VALUE_LESS_THAN
Type: STRING
Valid Values: N/A
Default: ''
Noninclusive upper bound for the current partition. Type a comma separated list in the same order as the columns in range partitioned key.
Properties for PARTITION_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: TYPE
Type: STRING
Valid Values: HASH, RANGE
Default: RANGE
Oracle partitions the storage space and stores rows according to a Hash Algorithm or specified ranges.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addViewSCOClause
This clause adds components like column etc.
propertyNameList
The list of properties.
propertyValueList
The list of property values.
addColumnClause
This column adds a column.
addViewConstraintClause
This clause adds the view's configuration clause.
addConfigurationClause
This clause will add configuration objects.
propertyValue
This clause adds the property values.
addUkPkClause
This clause adds the adds unique key and primary keys.
QUOTED_STRING
name of the unique key or primary key.
addFkClause
This clause adds foreign key
QUOTED_STRING
Name of the foreign key.
addIndexClause
This clause adds an index.
QUOTED_STRING
Name of the index.
addPartitionClause
This clause adds a partition.
QUOTED_STRING
Name of the partition.
addPartitionKeyClause
This clause adds a partition key.
QUOTED_STRING
Name of the partition key. This should be a column identifier.
addIndexColumnClause
This clause will add indexColumn to a specified index.
QUOTED_STRING
Index name
setUkPkPropertiesAndReferencesColumnsClauses
This clause adds properties and references to columns
setFkSubClauses
This clause set references to a foreign key.
setSCOConfigurationPropertiesClauses
Set the configuration properties for the following objects Index: LOGGING_MODE, PARALLEL_ACCESS_MODE, TABLESPACE, INDEX_TYPE, LOCAL_INDEX, DEPLOYABLE Partition: DATE_LESS_THAN, TABLESPACE, DEPLOYABLE Partition_key: TYPE, DEPLOYABLE RelationalCmdParser$constraintColumnReferencesClause = This clause provides names of all columns.
constraintColumnReferencesClause
RelationalCmdParser$constraintColumnReferencesClause??
setFkReferencesClauses
This clause sets foreign key references.
quotedNameList
This clause gives column names.
constraintUkReferencesClause
The first QUOTED_STRING denotes the UniqueKey or Primay key name, and the latter denotes the table's or view's name.
OMBCREATE MATERIALIZED_VIEW 'NEW_MATERIALIZED_VIEW' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a new materialized view', 'New MaterializedView') This will create a materialized view named "NEW_VIEW", its description is "this is a new materialized view", and business name is "New MaterializedView".
OMBCREATE, OMBALTER MATERIALIZED_VIEW, OMBDROP MATERIALIZED_VIEW
OMBCREATE OBJECT_TYPE - To create an Object Type.
Should be in the context of an Oracle Module.
createObjectTypeCommand = OMBCREATE ( OBJECT_TYPE "QUOTED_STRING" [ SET "setPropertiesClause" ] [ "addObjectAttributesClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addObjectAttributesClause = "addAttributeClause"+;propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };addAttributeClause = ADD OBJECT_TYPE_ATTRIBUTE "QUOTED_STRING" [ SET "setPropertiesClause" ];propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createObjectTypeCommand
Creates an Object Type with the given name.
setPropertiesClause
Sets properties (core, logical, physical, user-defined) for Object Type or its Attributes. Valid properties are shown below:
Basic properties for OBJECT_TYPE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Object Type
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Object Type
Basic properties for OBJECT_TYPE_ATTRIBUTE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Attribute
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Attribute
Name: DATATYPE
Type: STRING(20)
Valid Values: NUMBER, VARCHAR2, VARCHAR, DATE, FLOAT
Default: ''
Datatype of the Attribute
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addObjectAttributesClause
Adds one or more Attributes in this Object Type.
propertyNameList
The list of properties.
propertyValueList
The list of property values.
addAttributeClause
Adds an Attribute with the given name and properties.
propertyValue
This clause adds the property values.
OMBCREATE OBJECT_TYPE 'NEW_OBJECT_TYPE' SET PROPERTIES (DESCRIPTION) VALUES
('this is an object type') ADD OBJECT_TYPE_ATTRIBUTE 'ATTR' SET PROPERTIES (DATATYPE) VALUES ('VARCHAR2') This will create an Object Type named "NEW_OBJECT_TYPE", its description is "this is an object type" and an Attribute 'ATTR' of Varchar2 type.
OMBCREATE, OMBALTER OBJECT_TYPE, OMBDROP OBJECT_TYPE
OMBCREATE ORACLE_MODULE - To create an Oracle module.
Should be in the context of project.
createOracleModuleCommand = OMBCREATE ( ORACLE_MODULE "QUOTED_STRING" [ SET ( "setPropertiesClause" [ SET "setReferenceLocationClause" ] | "setReferenceLocationClause" ) ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setReferenceLocationClause = ( REFERENCE | REF ) LOCATION "QUOTED_STRING";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createOracleModuleCommand
This command creates an Oracle module
QUOTED_STRING
Name of the Oracle module to be created.
setPropertiesClause
Associate a set of properties with an Oracle module.
Basic properties for ORACLE_MODULE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: NAME
Business name of an Oracle Module
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of an Oracle Module
Name: UOID
Type: STRING(40)
Valid Values: N/A
Default: N/A
UOID of an Oracle Module
Properties for ORACLE_MODULE:
Name: ABAP_DIRECTORY
Type: STRING
Valid Values: N/A
Default: abap\
Location where ABAP scripts are stored
Name: ABAP_EXTENSION
Type: STRING
Valid Values: N/A
Default: .abap
File name extension for ABAP scripts
Name: ABAP_RUN_PARAMETER_FILE
Type: STRING
Valid Values: N/A
Default: _run.ini
Run Parameter File Suffix for the parameter script in a ABAP job.
Name: ABAP_SPOOL_DIRECTORY
Type: STRING
Valid Values: N/A
Default: abap\log\
Location where ABAP scripts are buffered during script generation processing.
Name: APPLICATION_SHORT_NAME
Type: STRING
Valid Values: N/A
Default: WB
Application Short Name
Name: ARCHIVE_DIRECTORY
Type: STRING
Valid Values: N/A
Default: archive\
Archive Directory
Name: CONNECT_STRING
Type: STRING
Valid Values: N/A
Default: ''
A Net*8 style connection string to the remote database. Alternatively, you can specify machine, port, service name of the remote database.
Name: DDL_DIRECTORY
Type: STRING
Valid Values: N/A
Default: ddl\
Location where scripts for database objects for the target schema are stored.
Name: DDL_EXTENSION
Type: STRING
Valid Values: N/A
Default: .ddl
File name extension for DDL scripts.
Name: DDL_SPOOL_DIRECTORY
Type: STRING
Valid Values: N/A
Default: ddl\log\
Location where DDL scripts are buffered during script generation processing.
Name: DEFAULT_INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Default name of tablespace to install indexes into.
Name: DEFAULT_OBJECT_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Default name of tablespace to install objects into.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: END_OF_LINE
Type: STRING
Valid Values: N/A
Default: \r\n
End of Line
Name: INPUT_DIRECTORY
Type: STRING
Valid Values: N/A
Default: input\
Input Directory
Name: INVALID_DIRECTORY
Type: STRING
Valid Values: N/A
Default: invalid\
Directory for SQL*Loader errors and rejected records
Name: LIB_DIRECTORY
Type: STRING
Valid Values: N/A
Default: lib\
LIB Directory
Name: LIB_EXTENSION
Type: STRING
Valid Values: N/A
Default: .lib
LIB Extension
Name: LIB_SPOOL_DIRECTORY
Type: STRING
Valid Values: N/A
Default: lib\log\
LIB Spool Directory
Name: LOADER_DIRECTORY
Type: STRING
Valid Values: N/A
Default: ctl\
Location where control files are stored.
Name: LOADER_EXTENSION
Type: STRING
Valid Values: N/A
Default: .ctl
Suffix for the loader scripts
Name: LOADER_RUN_PARAMETER_FILE
Type: STRING
Valid Values: N/A
Default: _run.ini
Suffix for the parameter initialization file.
Name: LOG_DIRECTORY
Type: STRING
Valid Values: N/A
Default: log\
Log Directory for the SQL*Loader
Name: MAIN_APPLICATION_SHORT_NAME
Type: STRING
Valid Values: N/A
Default: ora
Main Application Short Name
Name: PLSQL_DIRECTORY
Type: STRING
Valid Values: N/A
Default: pls\
Location where PL/SQL scripts are stored.
Name: PLSQL_EXTENSION
Type: STRING
Valid Values: N/A
Default: .pls
File name extension for PL/SQL scripts.
Name: PLSQL_GENERATION_MODE
Type: STRING
Valid Values: Oracle9i, Oracle8i
Default: Oracle9i
Generation mode controls validation and generation for version specific features.
Name: PLSQL_RUN_PARAMETER_FILE
Type: STRING
Valid Values: N/A
Default: _run.ini
Suffix for the parameter script in a PL/SQL job.
Name: PLSQL_SPOOL_DIRECTORY
Type: STRING
Valid Values: N/A
Default: pls\log\
Location where PL/SQL scripts are buffered during script generation processing.
Name: PORT
Type: STRING
Valid Values: N/A
Default: ''
The port number on the machine where the database listens to.
Name: RECEIVE_DIRECTORY
Type: STRING
Valid Values: N/A
Default: receive\
Receive Directory
Name: REMOTE_HOST_NAME
Type: STRING
Valid Values: N/A
Default: ''
The machine where the remote database resides on.
Name: SCHEMA_OWNER
Type: STRING
Valid Values: N/A
Default: OWB
Schema Owner
Name: SERVICE_NAME
Type: STRING
Valid Values: N/A
Default: ''
The service name (global DB name) of the database instance on the remote machine.
Name: SORT_DIRECTORY
Type: STRING
Valid Values: N/A
Default: sort\
Sort Directory
Name: TCL_DIRECTORY
Type: STRING
Valid Values: N/A
Default: tcl\
Location for TCL scripts that are generated after registration with Oracle Enterprise Manager
Name: TOP_DIRECTORY
Type: STRING
Valid Values: N/A
Default: ..\..\codegen\
Top Directory where generated code will get stored
Name: WORK_DIRECTORY
Type: STRING
Valid Values: N/A
Default: work\
Work Directory
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
setReferenceLocationClause
Set a location to an Oracle module.
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
propertyValue
Value of a property.
OMBCREATE ORACLE_MODULE 'src_module' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is an Oracle module', 'source module') This will create an Oracle module named "src_module", its description is "this is an Oracle module", and business name is "source module".
OMBCREATE, OMBALTER ORACLE_MODULE, OMBDROP ORACLE_MODULE
OMBCREATE PACKAGE - To create a Package.
Should be in the context of a Oracle Module or Transformation Module.
createPackageCommand = OMBCREATE ( PACKAGE "QUOTED_STRING" [ SET "setPropertiesClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createPackageCommand
This command creates a Package
QUOTED_STRING
Name of the Package to be created.
setPropertiesClause
Used to set properties (core, user-defined) for packages. Valid properties are shown below:
Basic properties for PACKAGE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Package
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Package
Properties for PACKAGE:
Name: AUTHID
Type: STRING
Valid Values: None, Current_User, Definer
Default: None
Generate the package with selected AUTHID option. Function will be executed with the permissions defined by the AUTHID clause rather than the function owner's permissions.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
propertyValue
Value of a property.
OMBCREATE PACKAGE 'pkg' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a Package', 'package') This will create a Package named "pkg", its description is "this is a Package", and business name is "package".
OMBCREATE, OMBALTER PACKAGE, OMBDROP PACKAGE
OMBCREATE PROCEDURE - To create a Procedure.
Should be in the context of a Oracle Module or Package or Transformation Module.
createProcedureCommand = OMBCREATE ( PROCEDURE "QUOTED_STRING" [ SET "setPropertiesClause" ] { ADD "addFuncProcParameterClause" } );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addFuncProcParameterClause = PARAMETER "QUOTED_STRING" [ SET "setPropertiesClause" ];propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createProcedureCommand
This command creates a Procedure
QUOTED_STRING
Name of the Procedure to be created.
setPropertiesClause
Used to set properties (core, user-defined) for procedurefunction. Valid properties are shown below:
Basic properties for PROCEDURE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Procedure
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Procedure
Name: IMPLEMENTATION
Type: STRING
Valid Values: N/A
Default: ''
Set the code for Procedure which is included global variable declaration and code between BEGIN and END.
Basic properties for PARAMETER:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Parameter
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Parameter
Name: DATATYPE
Type: STRING
Valid Values: PLS_INTEGER, BINARY_INTEGER, BOOLEAN, NUMBER, FLOAT, CHAR, VARCHAR, VARCHAR2, DATE
Default: NUMBER
Set the data type for Parameter
Name: IN_OUT
Type: STRING
Valid Values: IN, OUT, INOUT
Default: 'IN'
Set the parameter mode for Parameter
Name: DEFAULT_VALUE
Type: STRING
Valid Values: N/A
Default: ''
Set the default value for Parameter
Properties for PROCEDURE:
Name: AUTHID
Type: STRING
Valid Values: None, Current_User, Definer
Default: None
Generate the transformation with selected AUTHID option. Function will be executed with the permissions defined by the AUTHID clause rather than the function owner's permissions.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addFuncProcParameterClause
Adds one or more Parameters to this Procedure.
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
propertyValue
Value of a property.
OMBCREATE PROCEDURE 'proc' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME, IMPLEMENTATION) VALUES ('this is a Procedure', 'proc', 'BEGIN END proc \;') ADD PARAMETER 'PARAM_1' SET PROPERTIES (DEXCRIPTION, BUSINESS_NAME, IN_OUT, DATATYPE, DEFAULT_VALUE) VALUES ('param_1', 'this is a param_1','IN', 'VARCHAR2', 'this is a Varchar2') ADD PARAMETER 'PARAM_2' SET PROPERTIES (DEXCRIPTION, BUSINESS_NAME, IN_OUT, DATATYPE, DEFAULT_VALUE) VALUES ('param_2', 'this is a param_2','INOUT', 'DATE', 'this is a Date') This will create a Procedure named "proc", its description is "this is a Procedure", and business name is "proc", return datatype NUMBER, and body of function as 'BEGIN END proc;'. It creates two parameters 'PARAM_1' and 'PARAM_2'
OMBCREATE, OMBALTER PROCEDURE, OMBDROP PROCEDURE
OMBCREATE PROCESS_FLOW - To create a Process Flow.
Should be in the context of a Process Flow Package.
createProcessFlowCommand = OMBCREATE ( PROCESS_FLOW "QUOTED_STRING" [ SET "setPropertiesClause" ] ( { ADD "addProcessParameterClause" } { ADD "addActivityClause" } { ADD "addTransitionClause" } { ADD "addUserDefinedParameterClause" } ) );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addProcessParameterClause = ( PARAMETER "QUOTED_STRING" ) [ SET "setPropertiesClause" ];addActivityClause = ( "addStandardActivityClause" | "addMapActivityClause" | "addFunctionActivityClause" | "addSubProcessActivityClause" );addTransitionClause = ( TRANSITION "QUOTED_STRING" ( FROM ACTIVITY "QUOTED_STRING" ) ( TO "QUOTED_STRING" ) ) [ SET "setPropertiesClause" ];addUserDefinedParameterClause = ( PARAMETER "QUOTED_STRING" OF USER_DEFINED ACTIVITY "QUOTED_STRING" ) [ SET "setPropertiesClause" ];propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };addStandardActivityClause = ( AND ACTIVITY "QUOTED_STRING" | OR ACTIVITY "QUOTED_STRING" | FORK ACTIVITY "QUOTED_STRING" | FTP ACTIVITY "QUOTED_STRING" | EMAIL ACTIVITY "QUOTED_STRING" | FILE_EXISTS ACTIVITY "QUOTED_STRING" | USER_DEFINED ACTIVITY "QUOTED_STRING" | END_WARNING ACTIVITY | END_ERROR ACTIVITY | END_SUCCESS ACTIVITY ) [ SET "setPropertiesClause" ];addMapActivityClause = ( MAPPING ACTIVITY "QUOTED_STRING" SET ( PROPERTIES "collectPropertiesClause" SET ( REF | REFERENCE ) "setPropertiesAndReferencesMapClauses" | ( REF | REFERENCE ) "setPropertiesAndReferencesMapClauses" ) );addFunctionActivityClause = ( TRANSFORMATION ACTIVITY "QUOTED_STRING" SET ( PROPERTIES "collectPropertiesClause" SET ( REF | REFERENCE ) "setPropertiesAndReferencesFunctionClauses" | ( REF | REFERENCE ) "setPropertiesAndReferencesFunctionClauses" ) );addSubProcessActivityClause = ( SUBPROCESS ACTIVITY "QUOTED_STRING" SET ( PROPERTIES "collectPropertiesClause" SET ( REF | REFERENCE ) "setPropertiesAndReferencesSubProcessClauses" | ( REF | REFERENCE ) "setPropertiesAndReferencesSubProcessClauses" ) );propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );collectPropertiesClause = "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setPropertiesAndReferencesMapClauses = ( MAPPING "QUOTED_STRING" );setPropertiesAndReferencesFunctionClauses = ( TRANSFORMATION "QUOTED_STRING" );setPropertiesAndReferencesSubProcessClauses = ( PROCESS_FLOW "QUOTED_STRING" );
createProcessFlowCommand
Create a new process flow using quoted name.
setPropertiesClause
Used to set properties (core, user-defined) for process flow. Note: For MAPPING, TRANSFORMATION and SUBPROCESS activities the setPropertiesAndReferencesMapClauses, setPropertiesAndReferencesFunctionClauses and setPropertiesAndReferencesSubProcessClauses respectively, are mandatory. For MAPPING or TRANSFORMATION activities and the REFERENCE property has to be set to a valid MAP or TRANSFORMATION within the current project. For SUBPROCESS activities the REFERENCE property has to be set to a SUBPROCESS within the same PROCESS_FLOW_PACKAGE. Valid properties are shown below:
Base properties for PROCESS_FLOW:
Basic properties for Process Flow, Activity, Transition and Parameter:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Process Flow
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Process Flow Core properties for Transition :
Name: TRANSITION_CONDITION
Type: STRING
Valid Values: '', SUCCESS, ERROR, WARNING
Default: '' i.e. Unconditional
Sets the Transition Condition of a Transition
Description of the Process Flow Core properties for Activity Parameter :
Name: DATATYPE
Type: STRING
Valid Values: INTEGER, FLOAT, DATE, STRING, BOOLEAN
Default: STRING
Sets the datatype of a Activity Parameter
Name: DIRECTION
Type: STRING
Valid Values: IN
Default: IN
Sets the direction of a Activity Parameter
Name: VALUE
Type: STRING
Valid Values:
'123', '123.456', 'Jan-08-2003', 'I am String', 'true'
Default: ''
For Mapping activities representing PLSQL maps, the allowed value for the parameters: OPERATING_MODE:'SET_BASED' 'ROW_BASED' 'ROW_BASED_TARGET_ONLY' 'SET_BASED_FAIL_OVER_TO_ROW_BASED' 'SET_BASED_FAIL_OVER_TO_ROW_BASED_TARGET_ONLY' AUDIT_LEVEL:'NONE' 'STATISTICS' 'ERROR_DETAILS' 'COMPLETE' Sets the value of a Activity Parameter
Name: BINDING
Type: STRING
Valid Values:
'PARAM_1', 'PARAM_2'
Default: ''
Represents the parameter on the process flow that this parameter is bound to. When setting users can specify the name of any PROCESS PARAMETER of same datatype. This feature allows for parameterizing the process flow. If the parameter is bound the VALUE property is ignored when generating the process flow. To unbind a parameter, use an empty quoted string ie. '', and the parameter will be unbound.
Properties for PROCESS_FLOW:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: ''
Physical name of the object that this activity represents.
Name: DEPLOYED_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Deployed Location of Transformation Activities only.
Name: EXECUTION_LOCATION
Type: STRING
Valid Values: N/A
Default: NATIVE_EXECUTION
The location from which this activity will be executed.
Name: REMOTE_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Remote Location for FTP activities only.
Name: USE_RETURN_AS_STATUS
Type: BOOLEAN
Valid Values: true, false
Default: false
Use any return value to select the Transition path.
Name: WORKING_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Working Location for FTP, FILE_EXIST and USER_DEFINED activites only.
Properties for ACTIVITY:
Name: BOUND_NAME
Type: STRING
Valid Values: N/A
Default: ''
Physical name of the object that this activity represents.
Name: DEPLOYED_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Deployed Location of Transformation Activities only.
Name: EXECUTION_LOCATION
Type: STRING
Valid Values: N/A
Default: NATIVE_EXECUTION
The location from which this activity will be executed.
Name: REMOTE_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Remote Location for FTP activities only.
Name: USE_RETURN_AS_STATUS
Type: BOOLEAN
Valid Values: true, false
Default: false
Use any return value to select the Transition path.
Name: WORKING_LOCATION
Type: STRING
Valid Values: N/A
Default: USE_DEFAULT_LOCATION
Working Location for FTP, FILE_EXIST and USER_DEFINED activites only.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addProcessParameterClause
This clause adds the Parameters for a Process Flow.
addActivityClause
This clause adds the Activities for a Process Flow.
addTransitionClause
This clause adds the Transitions for a Process Flow.
addUserDefinedParameterClause
This clause adds the Parametrers for a User Defined Activity of a Process Flow.
propertyNameList
A comma delimited set of property names to set.
propertyValueList
A comma delimited set of property values to set.
addStandardActivityClause
This clause adds standard activity types AND, FORK, FTP, OR, USER_DEFINED to a Process Flow.
addMapActivityClause
This clause adds the MAP activity to a Process Flow.
addFunctionActivityClause
This clause adds the Function or Procedure activity to a Process Flow.
addSubProcessActivityClause
This clause adds a Process as an activity to a Process Flow.
propertyValue
Integer value, float value or quoted string literal.
collectPropertiesClause
This clause collects core properties of Map, Function/Procedure and Subprocess activity.
setPropertiesAndReferencesMapClauses
This clause sets reference to the existing Map.
setPropertiesAndReferencesFunctionClauses
This clause sets a reference to existing Function or Procedure.
setPropertiesAndReferencesSubProcessClauses
This clause sets a reference to existing Process Flow.
OMBCREATE PROCESS_FLOW 'TEST_PROCESS_FLOW' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a Process Flow', 'process flow') ADD PARAMETER 'PARAM_1' ADD PARAMETER 'PARAM_2' ADD FORK ACTIVITY 'FORK_ACTIVITY' ADD USER_DEFINED ACTIVITY 'UD_ACTIVITY' ADD FTP ACTIVITY 'FTP_ACTIVITY' ADD OR ACTIVITY 'OR_ACTIVITY' ADD AND ACTIVITY 'AND_ACTIVITY' ADD MAPPING ACTIVITY 'ACTIVITY_MAP_1' SET REFERENCE MAPPING '/PROCESS_FLOW_PROJECT/WAREHOUSE_P/MAP_1' ADD SUBPROCESS ACTIVITY 'SUBPROCESS_ACTIVITY' SET REFERENCE PROCESS_FLOW 'REPORT_PROCESS_FLOW' ADD MAPPING ACTIVITY 'ACTIVITY_MAP_2' SET REFERENCE MAPPING '/PROCESS_FLOW_PROJECT/WAREHOUSE_P/MAP_2' ADD TRANSITION 'T1' FROM ACTIVITY 'START' TO 'FORK_ACTIVITY' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('SUCCESS') ADD TRANSITION 'T2' FROM ACTIVITY 'FORK_ACTIVITY' TO 'FTP_ACTIVITY' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('SUCCESS') ADD TRANSITION 'T3' FROM ACTIVITY 'FORK_ACTIVITY' TO 'ACTIVITY_MAP_1' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('SUCCESS') ADD TRANSITION 'T4' FROM ACTIVITY 'FTP_ACTIVITY' TO 'OR_ACTIVITY' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('SUCCESS') ADD TRANSITION 'T5' FROM ACTIVITY 'FTP_ACTIVITY' TO 'UD_ACTIVITY' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('ERROR') ADD TRANSITION 'T6' FROM ACTIVITY 'UD_ACTIVITY' TO 'OR_ACTIVITY' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('SUCCESS') ADD TRANSITION 'T7' FROM ACTIVITY 'OR_ACTIVITY' TO 'AND_ACTIVITY' ADD TRANSITION 'T8' FROM ACTIVITY 'ACTIVITY_MAP_1' TO 'AND_ACTIVITY' ADD TRANSITION 'T9' FROM ACTIVITY 'ACTIVITY_MAP_1' TO 'SUBPROCESS_ACTIVITY' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('WARNING') ADD TRANSITION 'T10' FROM ACTIVITY 'AND_ACTIVITY' TO 'ACTIVITY_MAP_2' ADD TRANSITION 'T11' FROM ACTIVITY 'ACTIVITY_MAP_2' TO 'SUBPROCESS_ACTIVITY' SET PROPERTIES (TRANSITION_CONDITION) VALUES ('WARNING') ADD TRANSITION 'T12' FROM ACTIVITY 'ACTIVITY_MAP_2' TO 'END' ADD TRANSITION 'T13' FROM ACTIVITY 'SUBPROCESS_ACTIVITY' TO 'END' ADD PARAMETER 'PARAM_1' OF USER_DEFINED ACTIVITY 'UD_ACTIVITY'
Prerequsite for this examples are the existance of a MAP_1, MAP_2 and a Process Flow 'REPORT_PROCESS_FLOW'. The example here will create a process flow and its parameters, it creates activity of types FTP, AND, OR, FORK, MAPPING, USER_DEFINED, and SUBPROCESS. It creates various types of transitions among these activities. At the end it creates a parameter for a user_defined activity type.
OMBCREATE, OMBALTER PROCESS_FLOW, OMBDROP PROCESS_FLOW
OMBCREATE PROCESS_FLOW_MODULE - To create a Process Flow Module.
Should be in the context of a project.
createProcessFlowModuleCommand = OMBCREATE ( PROCESS_FLOW_MODULE "QUOTED_STRING" [ SET ( "setPropertiesClause" [ SET "setReferenceLocationClause" ] | "setReferenceLocationClause" ) ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";setReferenceLocationClause = ( REFERENCE | REF ) LOCATION "QUOTED_STRING";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createProcessFlowModuleCommand
Create a new process flow module.
setPropertiesClause
Used to set properties (core, user-defined) for process flow module.
Base properties for PROCESS_FLOW_MODULE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: NAME
Business name of a Process Flow Module
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of a Process Flow Module
setReferenceLocationClause
Set a location to a supported workflow engine.
propertyNameList
Comma-separated list of property names. Property names are not in quotation marks.
propertyValueList
Comma-separated list of property values.
propertyValue
Value of a property.
OMBCREATE PROCESS_FLOW_MODULE 'process_Module' SET PROPERTIES (DESCRIPTION,
BUSINESS_NAME) VALUES ('this is a Process Flow Module', 'process flow module') This will create a Process Flow Module named "process_Module", its description is "this is a Process Flow Module", and business name is "process flow module".
OMBCREATE, OMBALTER PROCESS_FLOW_MODULE, OMBDROP PROCESS_FLOW_MODULE
OMBCREATE PROCESS_FLOW_PACKAGE - To create a Process Flow Package.
Should be in the context of a Process Flow Module.
createProcessFlowPackageCommand = OMBCREATE ( PROCESS_FLOW_PACKAGE "QUOTED_STRING" [ SET "setPropertiesClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createProcessFlowPackageCommand
Create a new process flow package.
setPropertiesClause
Used to set properties (core, user-defined) for process flow packages. Valid properties are shown below:
Basic properties for PROCESS_FLOW_PACKAGE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the Process Flow Package
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Process Flow Package
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyNameList
A comma delimited set of property names to set.
propertyValueList
A comma delimited set of property values to set.
propertyValue
Integer value, float value or quoted string literal.
OMBCREATE PROCESS_FLOW_PACKAGE 'process_Package' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a Process Flow Package', 'process flow package') This will create a Process Flow Package named "process_Package", its description is "this is a Process Flow Package", and business name is "process flow package".
OMBCREATE, OMBALTER PROCESS_FLOW_PACKAGE, OMBDROP PROCESS_FLOW_PACKAGE
OMBCREATE PROJECT - To create a project.
Should be in the top level context.
createProjectCommand = OMBCREATE ( PROJECT "QUOTED_STRING" [ SET "setPropertiesClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createProjectCommand
Create a project.
setPropertiesClause
Associate a set of properties with a project.
Basic properties for PROJECT:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: NAME
Business name of a Project
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of a Project
Name: UOID
Type: STRING(40)
Valid Values: N/A
Default: N/A
UOID of a Project
propertyNameList
Comma separated list of property names. Property names are unquoted.
propertyValueList
Comma separated list of property values.
propertyValue
Value of a property.
OMBCREATE PROJECT 'New Project' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME)
VALUES ('this is a project', 'payroll project') This will create a project named "New Project", its description is "this is a project", and business name is "payroll project".
OMBCREATE, OMBALTER PROJECT, OMBDROP PROJECT
OMBCREATE RUNTIME_REPOSITORY_CONNECTION - To create a runtime repository connection.
Should be in the context of a project.
createRuntimeRepositoryCommand = OMBCREATE ( RUNTIME_REPOSITORY_CONNECTION "QUOTED_STRING" "createRunReposSetPropertiesClause" );createRunReposSetPropertiesClause = SET PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createRuntimeRepositoryCommand
Create a new runtime repository connection.
createRunReposSetPropertiesClause
Set the specified properties of the runtime repository connection.
propertyNameList
The names of the properties whose values you want to set.
Properties for RUNTIME_REPOSITORY_CONNECTION:
Name: HOST
Type: STRING
Valid Values: N/A
Default: N/A
The host machine the runtime repository is installed on.
Name: PORT
Type: NUMBER
Valid Values: 0 - 65535
Default: N/A
The port number of the database in which the runtime repository is installed.
Name: SERVICE_NAME
Type: STRING
Valid Values: N/A
Default: N/A
The service name of the database in which the runtime repository is installed.
Name: CONNECT_AS_USER
Type: STRING
Valid Values: N/A
Default: N/A
The name of the database user you wish to connect to the runtime repository as.
Name: RUNTIME_REPOSITORY_OWNER
Type: STRING
Valid Values: N/A
Default: N/A
The name of the schema in which the runtime repository is installed.
All of the preceding properties are mandatory for OMBCREATE RUNTIME_REPOSITORY_CONNECTION.
Basic properties for RUNTIME_REPOSITORY_CONNECTION:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the runtime repository connection.
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the runtime repository connection.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyValueList
The values for the named properties.
propertyValue
A property value.
OMBCREATE RUNTIME_REPOSITORY_CONNECTION 'NEW_RR_CONNECTION' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME, HOST, PORT, SERVICE_NAME, CONNECT_AS_USER, RUNTIME_REPOSITORY_OWNER) VALUES ('this is a runtime repository', 'runtime repository', 'localhost', 1521, 'orcl9i', 'scott', 'runtime_repos') This will create a runtime repository connection named "new_repository", its description is "this is a runtime repository", and business name is "runtime repository".
OMBCREATE, OMBALTER RUNTIME_REPOSITORY_CONNECTION, OMBDROP RUNTIME_REPOSITORY_CONNECTION
OMBCREATE SEQUENCE - To create a sequence.
In the context of an Oracle Module.
createSequenceCommand = OMBCREATE ( SEQUENCE "QUOTED_STRING" [ SET "setPropertiesClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
createSequenceCommand
This command creates a sequence.
setPropertiesClause
Used to set properties (core, logical, physical, user-defined) for tables, columns, unique keys, foreign keys, primary keys, and check constraints. Valid properties are shown below:
Basic properties for SEQUENCE:
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the sequence.
Name: CURRVAL
Type: NUMBER
Valid Values: N/A
Default: 1
current increment value.
Name: NEXTVAL
Type: NUMBER
Valid Values: N/A
Default: 1
next increment value. next increment value.
Properties for SEQUENCE:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INCREMENT_BY
Type: NUMBER
Valid Values: -2147483648 - 2147483647
Default: 1
Sequence Incremented By
Name: START_WITH
Type: NUMBER
Valid Values: -2147483648 - 2147483647
Default: 1
Sequence Starts With
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
propertyNameList
The list of properties.
propertyValueList
The list of property values.
propertyValue
This clause adds the property values.
OMBCREATE SEQUENCE 'new_sequence' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a new sequence', 'New Sequence') This will create a sequence named "NEW_SEQUENCE", its description is "this is a new sequence", and business name is "New Sequence".
OMBCREATE, OMBALTER SEQUENCE, OMBDROP SEQUENCE
OMBCREATE SNAPSHOT - To create a snapshot of a component.
Component on which snapshot is to be created should already exist. This command can be executed for any component regardless of current context.
Syntax
parseCreateCommand = OMBCREATE "createSnapshotCommand";createSnapshotCommand = ( SNAPSHOT "QUOTED_STRING" [ WITH DEPENDEE_DEPTH ( MAX | "INTEGER_LITERAL" ) ] [ SET "setPropertiesClause" ] "addSnapshotFCOClauses" );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addSnapshotFCOClauses = ( ADD ( "folderObjectClause" | "entityObjectClause" ) )+;propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };folderObjectClause = ( FLAT_FILE_MODULE | INTELLIGENCE_MODULE | GATEWAY_MODULE | ORACLE_MODULE | PROJECT | REPORT_MODULE | SAP_MODULE | PACKAGE | PROCESS_FLOW_PACKAGE | PROCESS_FLOW_MODULE ) "QUOTED_STRING" [ CASCADE | NO CASCADE ];entityObjectClause = ( ( BUSINESS_AREA | COLLECTION | CUBE_TABLE | FUNCTION | PROCEDURE | DIMENSION_TABLE | EXTERNAL_TABLE | FLAT_FILE | IO_FUNCTION | MAPPING | MATERIALIZED_VIEW | QUERY_OBJECT | REPORT | REPORT_GROUP | SEQUENCE | TABLE | PROCESS_FLOW | LOCATION | CONNECTOR | ADVANCED_QUEUE | OBJECT_TYPE | RUNTIME_REPOSITORY_CONNECTION | VIEW ) "QUOTED_STRING" );propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );
parseCreateCommand
Root production for OMBCREATE SNAPSHOT.
createSnapshotCommand
Clause for creating snapshots.
QUOTED_STRING
Name of the snapshot to be created.
DEPENDEE_DEPTH
Optional clause to indicate whether the component's depedee components are to be included in the snapshot.
setPropertiesClause
Optional clause to set the properties of a snapshot.
Basic properties for SNAPSHOT:
Name: TYPE
Type: STRING(200)
Valid Values: FULL,SIGNATURE
Default: FULL
This is the type of snapshot
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the snapshot
PROPERTIES
Valid set of properties are DESCRIPTION and TYPE
VALUES
Values for the corresponding properties. Default values of properties for DESCRIPTION is null and valid values for TYPE are FULL or SIGNATURE
addSnapshotFCOClauses
Components to be added to the snapshot
propertyNameList
Property names for SNAPSHOT.
propertyValueList
List of property values for SNAPSHOT.
folderObjectClause
Folder components to be added to the snapshot
QUOTED_STRING
Absolute or relative path name of the component to be added to the snapshot
CASCADE
Cascade option for folder components. By default, any folder is snapshotted
along with its contents. The NO CASCADE option allows the user to snapshot only the folder object itself along with its associated properties.
entityObjectClause
Any non-folder component can be added to a snapshot.
propertyValue
Allowable value types for a snapshot property.
OMBCREATE SNAPSHOT 'S1' SET PROPERTIES (DESCRIPTION, TYPE) VALUES ('this is
snapshot', 'FULL') ADD TABLE '/Project1/WH1/T1'
This will create a snapshot named S1 with the T1 table component in it. OMBCREATE SNAPSHOT 'S1' WITH DEPENDEE_DEPTH 1 SET PROPERTIES (DESCRIPTION, TYPE) VALUES('this is snapshot with dependees', 'FULL') ADD MAPPING '/Project1/WH1/MAP1' This will create snapshot named S1 with the MAP1 mapping component. This command will find all the dependee components, which in this case would be all the components which the map references. For e.g. if MAP1 contains T1,T2 and T3, then this WITH DEPENDEE_DEPTH 1 option will take a snapshot of the map MAP1 and tables T1,T2, and T3.
OMBALTER SNAPSHOT, OMBDROP SNAPSHOT, OMBRESTORE SNAPSHOT, OMBCOMPARE SNAPSHOT, OMBLIST SNAPSHOT, OMBRETRIEVE SNAPSHOT
OMBCREATE TABLE - To create a table.
In the context of an Oracle Module.
createTableCommand = OMBCREATE ( TABLE "QUOTED_STRING" [ SET "setPropertiesClause" ] [ "addTableSCOClauses" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addTableSCOClauses = ADD ( "addColumnClause" | "addConstraintClause" | "addConfigurationClause" ) [ "addTableSCOClauses" ];propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };addColumnClause = COLUMN "QUOTED_STRING" [ SET "setPropertiesClause" ];addConstraintClause = "addUkPkClause" | "addFkClause" | "addCheckConstraintClause";addConfigurationClause = "addIndexClause" | "addPartitionClause" | "addPartitionKeyClause" | "addIndexColumnClause";propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );addUkPkClause = ( UNIQUE_KEY | PRIMARY_KEY ) "QUOTED_STRING" [ SET "setUkPkPropertiesAndReferencesColumnsClauses" ];addFkClause = FOREIGN_KEY "QUOTED_STRING" [ SET "setFkSubClauses" ];addCheckConstraintClause = CHECK_CONSTRAINT "QUOTED_STRING" [ SET "setPropertiesClause" ];addIndexClause = INDEX "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addPartitionClause = PARTITION "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addPartitionKeyClause = PARTITION_KEY "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addIndexColumnClause = INDEX_COLUMN "QUOTED_STRING" OF INDEX "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];setUkPkPropertiesAndReferencesColumnsClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "constraintColumnReferencesClause" ] | ( REF | REFERENCE ) "constraintColumnReferencesClause";setFkSubClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "setFkReferencesClauses" ] | ( REF | REFERENCE ) "setFkReferencesClauses";setSCOConfigurationPropertiesClauses = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";constraintColumnReferencesClause = COLUMNS "(" "quotedNameList" ")";setFkReferencesClauses = "constraintColumnReferencesClause" [ SET ( REF | REFERENCE ) "constraintUkReferencesClause" ] | "constraintUkReferencesClause" [ SET ( REF | REFERENCE ) "constraintColumnReferencesClause" ];quotedNameList = "QUOTED_STRING" { "," "QUOTED_STRING" };constraintUkReferencesClause = ( UNIQUE_KEY | PRIMARY_KEY ) "QUOTED_STRING" [ OF ( TABLE | VIEW ) "QUOTED_STRING" ];
createTableCommand
This command creates a table.
QUOTED_STRING
Specify the name of the table to be created.
setPropertiesClause
Used to set properties (core, logical, physical, user-defined) for tables, columns, unique keys, foreign keys, primary keys, and check constraints. Valid properties are shown below:
Basic properties for TABLE:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the table
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the table
Name: UOID
Type: STRING
Valid Values: N/A
Default: N/A
Basic properties for COLUMN:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the table
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the table
Name: DATATYPE
Type: STRING
Valid Values: NUMBER, VARCHAR, VARCHAR2, DATE, FLOAT
Default: NUMBER
The datatype of a column
Name: LENGTH
Type: NUMBER
Valid Values:
Default: 1
The length of a number
Name: PRECISION
Type: NUMBER
Valid Values: 0 - 39
Default: 1
The precision of a number.
Name: SCALE
Type: NUMBER
Valid Values: -85 - 125
Default: 1
The scale of a number.
Name: UOID
Type: STRING
Valid Values: N/A
Default: N/A
Basic properties for INDEX, PARTITION, PARTITION_KEY, INDEX_COLUMN:
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Index, Partition, PartitionKey, IndexColumn.
Properties for TABLE:
Name: ANALYZE_TABLE_ESTIMATE_PERCENT
Type: NUMBER
Valid Values: 0 - 100
Default: 99
Value represents the sample size as a percentage of total rows. When set to a nonzero value, Builder generates a DDL script to analyze the table.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: HASH_PARTITION_TABLESPACE_LIST
Type: STRING
Valid Values: N/A
Default: ''
A comma separated list of tablespaces to use for [sub]partition storage.
Name: HASH_SUBPARTITION_NUMBER
Type: NUMBER
Valid Values: 2 - 63999
Default: 2
To create Hash partition, specify the number of Hash subpartition.
Name: LOGGING_MODE
Type: STRING
Valid Values: NOLOGGING, LOGGING
Default: LOGGING
Recovery requirements for a data warehouse : Logging or not logging to Redo Log File.
Name: PARALLEL_ACCESS_MODE
Type: STRING
Valid Values: NOPARALLEL, PARALLEL
Default: PARALLEL
Enables or disables parallel processing when the table is created. Also enables or disables parallel processing or access.
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Use the Tablespace parameter to specify the name of tablespace.
Properties for UNIQUE_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for FOREIGN_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for CHECK_CONSTRAINT:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for INDEX:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: INDEX_TYPE
Type: STRING
Valid Values: BITMAP, UNIQUE, NO_INDEX
Default: UNIQUE
The types of Indexes created on Dimension are BITMAP, UNIQUE or a non-specific index.
Name: LOCAL_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
A local index is constructed so that it reflects the structure of the underlying table. It is equipartitioned with the underlying table, meaning that it is partitioned on the same columns as the underlying table, creates the same number of partitions or subpartitions, and gives them the same partition bounds as corresponding partitions of the underlying table.
Name: LOGGING_MODE
Type: STRING
Valid Values: NOLOGGING, LOGGING
Default: LOGGING
Recovery requirements for a data warehouse : Logging or not logging to Redo Log File.
Name: PARALLEL_ACCESS_MODE
Type: STRING
Valid Values: NOPARALLEL, PARALLEL
Default: PARALLEL
Enables or disables parallel processing when the table is created. Also enables or disables parallel processing or access.
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Use the Tablespace parameter to specify the name of tablespace.
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for PARTITION:
Name: DATE_LESS_THAN
Type: STRING
Valid Values: N/A
Default: TO_DATE('01-JAN-1999', 'DD-MON-YYYY')
Value that represents upper bound of partition stored in warehouse key column for the Days Dimension.
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: EMPTY_STRING
Use the Tablespace parameter to specify the name of tablespace.
Name: VALUES_LESS_THAN
Type: STRING
Valid Values: N/A
Default: TO_DATE('01-JAN-1999', 'DD-MON-YYYY')
Noninclusive upper bound for the current partition. Type a comma separated list in the same order as the columns in range partitioned key.
Name: VALUE_LESS_THAN
Type: STRING
Valid Values: N/A
Default: ''
Noninclusive upper bound for the current partition. Type a comma separated list in the same order as the columns in range partitioned key.
Properties for PARTITION_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: TYPE
Type: STRING
Valid Values: HASH, RANGE
Default: RANGE
Oracle partitions the storage space and stores rows according to a Hash Algorithm or specified ranges.
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addTableSCOClauses
This clause adds the secon class objects.
propertyNameList
The list of properties.
propertyValueList
The list of property values.
addColumnClause
This column adds a column.
addConstraintClause
Adds primary and unique key, and add check constraints.
addConfigurationClause
This clause will add configuration objects.
propertyValue
This clause adds the property values.
addUkPkClause
This clause adds the adds unique key and primary keys.
QUOTED_STRING
name of the unique key or primary key.
addFkClause
This clause adds foreign key
QUOTED_STRING
Name of the foreign key.
addCheckConstraintClause
add a check constraint.
QUOTED_STRING
Name of the CheckConstraint.
addIndexClause
This clause adds an index.
QUOTED_STRING
Name of the index.
addPartitionClause
This clause adds a partition.
QUOTED_STRING
Name of the partition.
addPartitionKeyClause
This clause adds a partition key.
QUOTED_STRING
Name of the partition key. This should be a column identifier.
addIndexColumnClause
This clause will add indexColumn to a specified index.
QUOTED_STRING
Index name
setUkPkPropertiesAndReferencesColumnsClauses
This clause adds properties and references to columns
setFkSubClauses
This clause set references to a foreign key.
setSCOConfigurationPropertiesClauses
Set the configuration properties for the following objects Index: LOGGING_MODE, PARALLEL_ACCESS_MODE, TABLESPACE, INDEX_TYPE, LOCAL_INDEX, DEPLOYABLE Partition: DATE_LESS_THAN, TABLESPACE, DEPLOYABLE Partition_key: TYPE, DEPLOYABLE RelationalCmdParser$constraintColumnReferencesClause = This clause provides names of all columns.
constraintColumnReferencesClause
RelationalCmdParser$constraintColumnReferencesClause??
setFkReferencesClauses
This clause sets foreign key references.
quotedNameList
This clause gives column names.
constraintUkReferencesClause
The first QUOTED_STRING denotes the UniqueKey or Primay key name, and the latter denotes the table's or view's name.
OMBCREATE TABLE 'new_table' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a new table', 'New Table') This will create a table named "NEW_TABLE", its description is "this is a new table", and business name is "New Table".
OMBCREATE, OMBALTER TABLE, OMBDROP TABLE
OMBCREATE VIEW - To create a view.
In the context of an Oracle Module.
createViewCommand = OMBCREATE ( VIEW "QUOTED_STRING" [ SET "setPropertiesClause" ] [ "addViewSCOClause" ] );setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";addViewSCOClause = ADD ( "addColumnClause" | "addViewConstraintClause" | "addConfigurationClause" ) [ "addViewSCOClause" ];propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" };propertyValueList = "propertyValue" { "," "propertyValue" };addColumnClause = COLUMN "QUOTED_STRING" [ SET "setPropertiesClause" ];addViewConstraintClause = "addUkPkClause" | "addFkClause";addConfigurationClause = "addIndexClause" | "addPartitionClause" | "addPartitionKeyClause" | "addIndexColumnClause";propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" );addUkPkClause = ( UNIQUE_KEY | PRIMARY_KEY ) "QUOTED_STRING" [ SET "setUkPkPropertiesAndReferencesColumnsClauses" ];addFkClause = FOREIGN_KEY "QUOTED_STRING" [ SET "setFkSubClauses" ];addIndexClause = INDEX "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addPartitionClause = PARTITION "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addPartitionKeyClause = PARTITION_KEY "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];addIndexColumnClause = INDEX_COLUMN "QUOTED_STRING" OF INDEX "QUOTED_STRING" [ SET "setSCOConfigurationPropertiesClauses" ];setUkPkPropertiesAndReferencesColumnsClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "constraintColumnReferencesClause" ] | ( REF | REFERENCE ) "constraintColumnReferencesClause";setFkSubClauses = "setPropertiesClause" [ SET ( REF | REFERENCE ) "setFkReferencesClauses" ] | ( REF | REFERENCE ) "setFkReferencesClauses";setSCOConfigurationPropertiesClauses = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")";constraintColumnReferencesClause = COLUMNS "(" "quotedNameList" ")";setFkReferencesClauses = "constraintColumnReferencesClause" [ SET ( REF | REFERENCE ) "constraintUkReferencesClause" ] | "constraintUkReferencesClause" [ SET ( REF | REFERENCE ) "constraintColumnReferencesClause" ];quotedNameList = "QUOTED_STRING" { "," "QUOTED_STRING" };constraintUkReferencesClause = ( UNIQUE_KEY | PRIMARY_KEY ) "QUOTED_STRING" [ OF ( TABLE | VIEW ) "QUOTED_STRING" ];
createViewCommand
This command creates a view.
QUOTED_STRING
Specify the name of the view to be created.
setPropertiesClause
Used to set properties (core, logical, physical, user-defined) for tables, columns, unique keys, foreign keys, primary keys, and check constraints.
Basic properties for VIEW, MATERIALIZED_VIEW:
Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: N/A
Default: ''
Business name of the View, MaterializedView
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the View, MaterializedView
Name: VIEW_QUERY
Type: STRING(4000)
Valid Values: N/A
Default: ''
Sets the query definition in View and MaterializedView.
Name: UOID
Type: STRING
Valid Values: N/A
Default: N/A
Basic properties for INDEX, PARTITION, PARTITION_KEY, INDEX_COLUMN:
Name: DESCRIPTION
Type: STRING(4000)
Valid Values: N/A
Default: ''
Description of the Index, Partition, PartitionKey, IndexColumn in a MaterializedView.
Properties for VIEW:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Properties for UNIQUE_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for FOREIGN_KEY:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Properties for CHECK_CONSTRAINT:
Name: DEPLOYABLE
Type: BOOLEAN
Valid Values: true, false
Default: true
Warehouse Builder generates a set of scripts to create an object only for those object marked as Deployable = true
Name: INDEX_TABLESPACE
Type: STRING(30)
Valid Values: N/A
Default: ''
Tablespace to store Index on Table Constraint
Name: USING_INDEX
Type: BOOLEAN
Valid Values: true, false
Default: false
Use of Index on Dimension Constraint
Note:
1. N/A means any valid character in supported character set.
2. '' represents an empty string
addViewSCOClause
This clause adds components like column etc.
propertyNameList
The list of properties.
propertyValueList
The list of property values.
addColumnClause
This column adds a column.
addViewConstraintClause
This clause adds the view's configuration clause.
addConfigurationClause
This clause will add configuration objects.
propertyValue
This clause adds the property values.
addUkPkClause
This clause adds the adds unique key and primary keys.
QUOTED_STRING
name of the unique key or primary key.
addFkClause
This clause adds foreign key
QUOTED_STRING
Name of the foreign key.
addIndexClause
This clause adds an index.
QUOTED_STRING
Name of the index.
addPartitionClause
This clause adds a partition.
QUOTED_STRING
Name of the partition.
addPartitionKeyClause
This clause adds a partition key.
QUOTED_STRING
Name of the partition key. This should be a column identifier.
addIndexColumnClause
This clause will add indexColumn to a specified index.
QUOTED_STRING
Index name
setUkPkPropertiesAndReferencesColumnsClauses
This clause adds properties and references to columns
setFkSubClauses
This clause set references to a foreign key.
setSCOConfigurationPropertiesClauses
Set the configuration properties for the following objects Index: LOGGING_MODE, PARALLEL_ACCESS_MODE, TABLESPACE, INDEX_TYPE, LOCAL_INDEX, DEPLOYABLE Partition: DATE_LESS_THAN, TABLESPACE, DEPLOYABLE Partition_key: TYPE, DEPLOYABLE RelationalCmdParser$constraintColumnReferencesClause = This clause provides names of all columns.
constraintColumnReferencesClause
RelationalCmdParser$constraintColumnReferencesClause??
setFkReferencesClauses
This clause sets foreign key references.
quotedNameList
This clause gives column names.
constraintUkReferencesClause
The first QUOTED_STRING denotes the UniqueKey or Primay key name, and the latter denotes the table's or view's name.
OMBCREATE VIEW 'NEW_VIEW' SET PROPERTIES (DESCRIPTION, BUSINESS_NAME) VALUES ('this is a new view', 'New View') This will create a view named "NEW_VIEW", its description is "this is a new view", and business name is "New View".
OMBCREATE, OMBALTER VIEW, OMBDROP VIEW