Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Association definition to be defined should not already exist. User must have CREATE_EXTENSIONMODEL system privilege and has to be connected in single user mode to run this command.
parseDefineAssociationCommand = OMBDEFINE ASSOCIATION_DEFINITION "QUOTED_STRING" [ ( ON | OF ) "modelClause" ] "setAssociationDefinitionPropertiesClause" { "addDependencyDefinitionClause" } modelClause = ( MODEL "QUOTED_STRING" | PLATFORM "QUOTED_STRING" | CONFIGURATION_TEMPLATE "QUOTED_STRING" ( ON | OF ) PLATFORM "QUOTED_STRING" ) setAssociationDefinitionPropertiesClause = SET PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" 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 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: CLASS_1 Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: N/A Class on one side of the association. NAME: CLASS_2 Type: STRING(200) Value Values: N/A Default: N/A Class on the other side of the association. Name: ROLE_1 Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: N/A Role on one side of the association. Name: ROLE_2 Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: N/A Role on the other side of the 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.
Mark this association so that the dependency engine will consider it when computing the lineage and impact dependencies. 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.