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

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