Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBCREATE CORRECTION_MAPS_ACTION_PLAN

Purpose

Create an action plan for creating correction maps.

Prerequisites

In the context of a data profile after creating a correction schema using a CORRECTION_SCHEMA_ACTION_PLAN.

Syntax

CreateActionPlanCommand =  ( OMBCREATE TRANSIENT ( ( DEPLOYMENT_ACTION_PLAN
           | ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN | 
          CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" { "addActionClause" } 
          )
     addActionClause =  ADD ACTION "QUOTED_STRING" [ SET "setClause" ]
     setClause =  ( "propertiesClause" [ SET "setReferenceClause" ] ) | 
          "setReferenceClause"
     propertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceClause =  ( REF | REFERENCE ) "ObjType" "QUOTED_STRING" { 
          "useClause" }
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     useClause =  USE DATA_RULE_USAGE "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

CreateActionPlanCommand

Create a correction schema action plan.

CreateActionPlanCommand

Name: DATA_RULE_USAGE_NAME

Type: String

Valid Values: Any data rule usage name associated with the profile table

Name: ERROR_HANDLING_STRATEGY

Type: String

One of IGNORE REPORT CLEANSE

This property determines the action to take when the rule fails. If the action is cleanse, then a CORRECTION_STRATEGY

is used to determine the specific cleansing action.

Name: CORRECTION_STRATEGY

Type: String

One of DISCARD DOMAINSOUNDEX DOMAINSIMILARITY DISCARD MIN MAX FD_MAPLET FIX_REMOTE UK_MATCHMERGE

This property determines the correction action to take when the rule fails.

Not all correction strategies are supported with all data rule types.

All rule type have DISCARD, CUSTOM, and <function name> as strategies. The specific strategies for each rule types are:

Data Rule Type Correction Strategy

DOMAIN_LIST_RULE DOMAINSOUNDEX

DOMAINSIMILARITY

DOMAIN_RANGE_RULE MIN

MAX

FUNCTIONAL_DEPENDENCY_RULE FD_MAPLET

REFERENCE_RULE FIX_REMOTE

IDENTITY_RULE UK_MATCHMERGE

The CUSTOM rule type will generate an empty function in the schema. The generated map will call the function to correct the error.

The <function name> strategy allows the user to call an existing function to correct the error. The format of the strategy is:

'|SOURCE_MOD/CF_1(IN VARCHAR2, IN VARCHAR2, IN VARCHAR2)|SOURCE_MOD/CF_1(IN VARCHAR2, IN VARCHAR2, IN VARCHAR2)'

where a function signature delimited by | is entered for each attribute of the rule. A normal rule with a single input parameter will have only one function.

Name: CORRECTION_ORDER

Type: NUMBER

Valid Values: 1-any number

Optional: This sets the relative order of the data corrections.

addActionClause

Add an action to an action plan.

QUOTED_STRING

Action name.

setClause

Set the properties of an action and/or associate an object with an action.

propertiesClause

Set the properties and/or associate/disassociate an object with an action.

setReferenceClause

Associate an object with an action.

ObjType

Object type. The only valid value is DATA_PROFILE_TABLE.

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values.

useClause

Currently used only in CORRECTION_SCHEMA_ACTION_PLAN.

propertyValue

Value of a property.

See Also

OMBPROFILE