Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
In the context of a data profile after creating a correction schema using a CORRECTION_SCHEMA_ACTION_PLAN.
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" )
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.