Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
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 data auditor name must not conflict with existing data auditor names, map names and the maps names that concurrent user tries to use.
createDataAuditorCommand = OMBCREATE DATA_AUDITOR "dataAuditorName" [ SET ( ( "setPropertiesClause" [ SET "setReferenceIconSetClause" ] ) | "setReferenceIconSetClause" ) ] { ADD "addOperatorClause" } dataAuditorName = "QUOTED_STRING" setPropertiesClause = PROPERTIES "propertyKeyList" VALUES "propertyValueList" setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING" addOperatorClause = "operatorType" OPERATOR "operatorName" [ SET "setPropertiesClause" ] [ BOUND TO "setBindingClause" ] propertyKeyList = "(" "propertyKey" { "," "propertyKey" } ")" propertyValueList = "(" "propertyValue" { "," "propertyValue" } ")" operatorType = "UNQUOTED_STRING" operatorName = "QUOTED_STRING" setBindingClause = "bindableLocator" propertyKey = "UNQUOTED_STRING" propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" ) bindableLocator = "bindableType" "bindableName" bindableType = "UNQUOTED_STRING" bindableName = "QUOTED_STRING"
Adds an operator to a data auditor.OMBCREATE DATA_AUDITOR 'MAP1'
SET PROPERTIES (business_name, description)
VALUES ('My map', 'Audit table foo')
ADD TABLE OPERATOR 'CUST_SRC'
BOUND TO TABLE '../SRC_MODULE/CUST_SRC'
Type of a mapping operator. The following operator types are available: CUBE, DIMENSION, MATERIALIZED_VIEW, TABLE, VIEW.
Basic properties for DATA_AUDITOR: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the data auditor Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the daa auditor Basic properties for OPERATOR: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the operator Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the operator #
Property | Type | Choices | Min | Max | Default | Description |
---|---|---|---|---|---|---|
ANALYZE_TABLE_SAMPLE_PERCENTAGE |
NUMBER |
none |
none |
none |
90 |
The default percentage of rows to be sampled when the target tables are analyzed for statistics to improve performance during insertion. |
ANALYZE_TABLE_STATEMENTS |
BOOLEAN |
true, false |
none |
none |
true |
Generate statistics collection statement if this is true. |
ANSI_SQL_SYNTAX |
BOOLEAN |
true, false |
none |
none |
true |
A switch between ANSI and Oracle SQL Syntax. |
BULK_PROCESSING_CODE |
BOOLEAN |
true, false |
none |
none |
true |
Generate bulk processing code if this is true. |
BULK_SIZE |
NUMBER |
none |
none |
none |
50 |
|
COMMIT_CONTROL |
STRING |
AUTO_COMMIT, AUTO_CORR_COMMIT, MANUAL_COMMIT |
none |
none |
AUTO_COMMIT |
Options for how commit is performed |
COMMIT_FREQUENCY |
NUMBER |
none |
none |
none |
1000 |
|
DEBUG_RUNTIME_CONNECTION |
STRING |
none |
none |
none |
empty string |
Runtime schema connection info for debug. |
DEFAULT_AUDIT_LEVEL |
STRING |
COMPLETE, ERROR_DETAILS, NONE, STATISTICS |
none |
none |
STATISTICS |
The default audit level when the step is executed. |
DEFAULT_OPERATING_MODE |
STRING |
ROW_BASED, ROW_BASED_TARGET_ONLY, SET_BASED, SET_BASED_FAIL_OVER_TO_ROW_BASED, SET_BASED_FAIL_OVER_TO_ROW_BASED_TARGET_ONLY |
none |
none |
SET_BASED |
The default operating mode. |
DEFAULT_PURGE_GROUP |
STRING |
none |
none |
none |
WB |
The default purge group to be used when the step is executed. |
DEPLOYABLE |
BOOLEAN |
true, false |
none |
none |
true |
True if the map is deployable to a physical implementation |
DIAGRAM_LAYOUT |
STRING |
none |
none |
none |
empty string |
|
ENABLE_PARALLEL_DML |
BOOLEAN |
true, false |
none |
none |
false |
Determine if PDML is enabled at runtime. |
ERROR_TRIGGER |
STRING |
none |
none |
none |
empty string |
Error trigger procedure name. |
EXECUTION_TYPE |
STRING |
BATCH, TRICKLE |
none |
none |
BATCH |
Batch if this map is to be executed in batch; Trickle if this map is to be executed as a real-time map. |
GENERATION_COMMENTS |
STRING |
none |
none |
none |
empty string |
Enter additional comments for the generated code. |
GENERATION_LANGUAGE |
STRING |
PLSQL, UNDEFINED |
none |
none |
UNDEFINED |
The language used when generating code for the mapping. |
GENERATION_MODE |
STRING |
ALL_MODES, ROW_BASED, ROW_BASED_TARGET_ONLY, SET_BASED, SET_BASED_FAIL_OVER_TO_ROW_BASED, SET_BASED_FAIL_OVER_TO_ROW_BASED_TARGET_ONLY |
none |
none |
SET_BASED |
The operating modes for which code should be generated. |
MAXIMUM_NUMBER_OF_ERRORS |
NUMBER |
none |
none |
none |
50 |
The default maximum number of errors encountered before aborting the step execution. |
MAX_CHUNK_ITERATOR_COUNT |
NUMBER |
none |
none |
none |
50 |
The maximum number of chunking iterations allowed for this map, if chunking is switched on for any source. |
OPTIMIZED_CODE |
BOOLEAN |
true, false |
none |
none |
true |
Attempt to generate optimized code if this is true. |
REFERRED_CALENDAR |
STRING |
none |
none |
none |
empty string |
Enter the Schedule to associate with this object. |
STOP_CHUNKING_IF_NO_DATA |
BOOLEAN |
true, false |
none |
none |
true |
Stop chunk processing if no rows are processed for a given chunk iterator value (serial chunking only). |
TARGET_LOAD_ORDER |
STRING(65535) |
none |
none |
none |
empty string |
The Target Load Order property allows you to determine the order in which multiple targets within the same mapping get loaded. Warehouse Builder determines a default order based on the FK relationships. However, using the property you can overrule that default order. |
TARGET_LOAD_ORDERING |
BOOLEAN |
true, false |
none |
none |
true |
Generate target load ordering code. |
THRESHOLD_MODE |
STRING |
PERCENTAGE, SIX_SIGMA |
none |
none |
PERCENTAGE |
Use six sigma or percentage for failure thresholds. |
Property | Type | Choices | Min | Max | Default | Description |
---|---|---|---|---|---|---|
DEBUG_BRKPT_ENABLED |
BOOLEAN |
true, false |
none |
none |
false |
|
DEBUG_BRKPT_SET |
BOOLEAN |
true, false |
none |
none |
false |
|
DEBUG_USE_AS_SOURCE |
BOOLEAN |
true, false |
none |
none |
false |
|
DEBUG_WATCH_SET |
BOOLEAN |
true, false |
none |
none |
false |
|
HEIGHT |
NUMBER |
none |
none |
none |
150 |
|
IS_MAXIMIZED |
BOOLEAN |
true, false |
none |
none |
false |
|
IS_MINIMIZED |
BOOLEAN |
true, false |
none |
none |
false |
|
WIDTH |
NUMBER |
none |
none |
none |
180 |
|
X_COORDINATE |
NUMBER |
none |
none |
none |
0 |
|
Y_COORDINATE |
NUMBER |
none |
none |
none |
0 |