OMBRETRIEVE DATA_AUDITOR

Purpose

Retrieve data auditor details such as the number of operators.

Prerequisites

The current context must be in an Oracle Module.

Syntax

retrieveDataAuditorCommand =  OMBRETRIEVE DATA_AUDITOR "dataAuditorName" 
          "getDataAuditorDetailClause"
     dataAuditorName =  "QUOTED_STRING"
     getDataAuditorDetailClause =  GET ( PROPERTIES "propertyKeyList" | 
          "getReferenceIconSetClause" | [ "operatorType" ] OPERATORS | 
          "childType" ) | "getChildDetailClause" | "operatorLocator" 
          "getOperatorDetailClause"
     propertyKeyList =  "(" "propertyKey" { "," "propertyKey" } ")"
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     operatorType =  "UNQUOTED_STRING"
     childType =  "UNQUOTED_STRING"
     getChildDetailClause =  ( "childType" "childName" )+ GET ( PROPERTIES 
          "propertyKeyList" | "childType" )
     operatorLocator =  OPERATOR "operatorName"
     getOperatorDetailClause =  GET ( PROPERTIES "propertyKeyList" | 
          BOUND_OBJECT | "childType" ) | "getChildDetailClause"
     propertyKey =  "UNQUOTED_STRING"
     childName =  "QUOTED_STRING"
     operatorName =  "QUOTED_STRING"

Parameters

retrieveDataAuditorCommand

Retrieve the detail of a data auditor such as how many operators are there.

dataAuditorName

Name of data auditor.

getDataAuditorDetailClause

Get properties or operators from the data auditor.

propertyKeyList

The list of property keys.

getReferenceIconSetClause

Retrieve the icon set referenced by the data auditor.

operatorType

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

childType

Type of a child that belongs to data auditor or operator

getChildDetailClause

Get the desired detail of a child object that belongs to the data auditor or operator.

operatorLocator

Locate operator.

getOperatorDetailClause

Get the desired detail of a data auditor 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

#

childName

Name of a child that belongs to data auditor, operator.

operatorName

Name of an operator.

DATA_AUDITOR Object

Table 18-7 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 18-8 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

OMBRETRIEVE DATA_AUDITOR

Purpose

Prerequisites

Syntax

Parameters

retrieveDataAuditorCommand

dataAuditorName

getDataAuditorDetailClause

propertyKeyList

getReferenceIconSetClause

operatorType

childType

getChildDetailClause

operatorLocator

getOperatorDetailClause

propertyKey

propertyKey

childName

operatorName

DATA_AUDITOR Object

OPERATOR Object

See Also