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

OMBALTER DATA_AUDITOR

Purpose

Alter the content of a data auditor.

Prerequisites

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

2. No concurrent user should be modifying the data auditor

Syntax

alterDataAuditorCommand =  OMBALTER DATA_AUDITOR "dataAuditorName" ( 
          "renameClause" [ "alterPropertiesOrIconSetClause" ] [ 
          "alterDataAuditorDecendantsClause" ] | 
          "alterPropertiesOrIconSetClause" [ "alterDataAuditorDecendantsClause" 
          ] | "alterDataAuditorDecendantsClause" )
     dataAuditorName =  "QUOTED_STRING"
     renameClause =  RENAME TO "QUOTED_STRING"
     alterPropertiesOrIconSetClause =  ( SET ( ( "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ] ) 
          | "setReferenceIconSetClause" ) ) | UNSET 
          "unsetReferenceIconSetClause"
     alterDataAuditorDecendantsClause =  ( ADD "addOperatorClause" | MODIFY ( 
          "modifyOperatorClause" | "modifyChildClause" ) | DELETE 
          "operatorLocator" )+
     setPropertiesClause =  PROPERTIES "propertyKeyList" VALUES 
          "propertyValueList"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     addOperatorClause =  "operatorType" OPERATOR "operatorName" [ SET 
          "setPropertiesClause" ] [ BOUND TO "setBindingClause" ]
     modifyOperatorClause =  "operatorLocator" ( SET "setPropertiesClause" )
     modifyChildClause =  "childBottomUpLocator" ( "renameClause" | SET 
          "setPropertiesClause" )
     operatorLocator =  OPERATOR "operatorName"
     propertyKeyList =  "(" "propertyKey" { "," "propertyKey" } ")"
     propertyValueList =  "(" "propertyValue" { "," "propertyValue" } ")"
     operatorType =  "UNQUOTED_STRING"
     operatorName =  "QUOTED_STRING"
     setBindingClause =  "bindableLocator"
     childBottomUpLocator =  "childType" "childName" { OF "childType" 
          "childName" } [ OF "mappableBottomUpLocator" ]
     propertyKey =  "UNQUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     bindableLocator =  "bindableType" "bindableName"
     childType =  "UNQUOTED_STRING"
     childName =  "QUOTED_STRING"
     mappableBottomUpLocator =  "operatorLocator"
     bindableType =  "UNQUOTED_STRING"
     bindableName =  "QUOTED_STRING"

Parameters

alterDataAuditorCommand

Alter the content of a data auditor.

dataAuditorName

Name of data auditor.

renameClause

Rename a data auditor

alterPropertiesOrIconSetClause

Alter properties or the icon set.

alterDataAuditorDecendantsClause

Add, modify, delete or alter operators.

setPropertiesClause

Set the properties of the data auditor.

setReferenceIconSetClause

Set icon set for the data auditor.

unsetReferenceIconSetClause

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

modifyOperatorClause

Modify operator.

modifyChildClause

Modify a child that belongs to a data auditor.

operatorLocator

Locate operator.

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.

childBottomUpLocator

Locate object in data auditor.

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.

childType

Type of a child that belongs to data auditor or operator

childName

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

mappableBottomUpLocator

Locate mappable object in data auditor.

bindableType

Type of object bound to an operator.

bindableName

Name of the object bound to operator.

DATA_AUDITOR Object

Table 2-3 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 2-4 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