OMBCREATE DATA_AUDITOR

Purpose

Create a data auditor in an Oracle Module.

Prerequisites

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

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

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

Syntax

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"

Parameters

createDataAuditorCommand

Create a data auditor in an Oracle Module.

dataAuditorName

Name of data auditor.

setPropertiesClause

Set the properties of the data auditor.

setReferenceIconSetClause

Set icon set for the data auditor.

addOperatorClause

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'

propertyKeyList

The list of property keys.

propertyValueList

A list of property values.

operatorType

Type of a mapping operator. The following operator types are available: CUBE, DIMENSION, MATERIALIZED_VIEW, TABLE, VIEW.

operatorName

Name of an operator.

setBindingClause

Set the binding during the creation of a operator.

propertyKey

A property key for an object.

propertyKey

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

#

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 an operator.

bindableType

Type of object bound to an operator.

bindableName

Name of the object bound to operator.

DATA_AUDITOR Object

Table 7-1 DATA_AUDITOR Object

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.

OPERATOR Object

Table 7-2 OPERATOR Object

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

OMBCREATE DATA_AUDITOR

Purpose

Prerequisites

Syntax

Parameters

createDataAuditorCommand

dataAuditorName

setPropertiesClause

setReferenceIconSetClause

addOperatorClause

propertyKeyList

propertyValueList

operatorType

operatorName

setBindingClause

propertyKey

propertyKey

propertyValue

bindableLocator

bindableType

bindableName

DATA_AUDITOR Object

OPERATOR Object

See Also