Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Association definition to be redefined should already exist. This command can be executed for any association definition regardless of current context. User must have CREATE_EXTENSIONMODEL system privilege and has to be connected in single user mode to run this command.
parseRedefineAssociationCommand = OMBREDEFINE ASSOCIATION_DEFINITION "QUOTED_STRING" [ ( ON | OF ) "modelClause" ] ( RENAME TO "QUOTED_STRING" | "setAssociationDefinitionPropertiesClause" | ( "modifyDependencyDefinitionClause" | "deleteDependencyDefinitionClause" | "addDependencyDefinitionClause" )+ ) modelClause = ( MODEL "QUOTED_STRING" | PLATFORM "QUOTED_STRING" | CONFIGURATION_TEMPLATE "QUOTED_STRING" ( ON | OF ) PLATFORM "QUOTED_STRING" ) setAssociationDefinitionPropertiesClause = SET PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" modifyDependencyDefinitionClause = MODIFY DEPENDENCY_DEFINITION "QUOTED_STRING" "setDependencyDefinitionPropertiesClause" deleteDependencyDefinitionClause = DELETE DEPENDENCY_DEFINITION "QUOTED_STRING" addDependencyDefinitionClause = ADD DEPENDENCY_DEFINITION "QUOTED_STRING" [ "setDependencyDefinitionPropertiesClause" ] propertyNameList = "propertyNameClause" { "," "propertyNameClause" } propertyValueList = "propertyValue" { "," "propertyValue" } setDependencyDefinitionPropertiesClause = SET PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" propertyNameClause = ( "UNQUOTED_STRING" ) propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" )
Basic properties for re-defining ASSOCIATION_DEFINITION: Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: N/A A descriptive text for this association. Name: ROLE_1_MIN_CARDINALITY Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: N/A Minimum cardinality of role 1. Value can be positive integer. Name: ROLE_1_MAX_CARDINALITY Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: N/A Maximum cardinality of role 1. Value can be positive integer or 'INFINITE'. Name: ROLE_1_NAVIGABLE Type: BOOLEAN Valid Values: true, false Default: From user defined class side default is true. From OWB class side default is false. Navigability of role 1. Name: ROLE_2_MIN_CARDINALITY Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: N/A Minimum cardinality of role 2. Value can be positive integer. Name: ROLE_2_MAX_CARDINALITY Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: N/A Maximum cardinality of role 2. Value can be positive integer or 'INFINITE'. Name: ROLE_2_NAVIGABLE Type: BOOLEAN Valid Values: true, false Default: From user defined class side default is true. From OWB class side default is false. Navigability of role 2.
Modifies the properties of the specified dependency for this association.
Un-mark this association so that the dependency engine will ignore it when computing the lineage and impact dependencies of that type.
Mark this association so that the dependency engine will consider it when computing the lineage and impact dependencies of the specified type. The only dependency type allowed here for now is 'DATAFLOW'.
Basic dependency-related properties for this association:
Name: SOURCE_ROLE_ID
Type: STRING(200)
Valid Values: ROLE_1, ROLE_2
Default: If one of the ends is a OWB class, then that is the default source. If both ends are user defined classes, then the association is default bidirectional.
Identifies the role (end) of the association which serves as the source for the dependency flow.
Name: BIDIRECTIONAL
Type: BOOLEAN
Valid Values: true, false
Default: If one of the ends is a OWB class, then default is false. If both ends are user defined classes, then default is true.
Specifies whether the association is bi-directional for the dependency flow.