public class SetComponent extends DefaultDelegate
DefaultDelegate.DefaultAttributeDelegate, DefaultDelegate.DefaultConnectorPointDelegate
oracle.odi.domain.mapping.MapComponentDelegate.AttributeDelegate, oracle.odi.domain.mapping.MapComponentDelegate.MapConnectorPointDelegate
IMapComponent.ComponentCategory
Modifier and Type | Field and Description |
---|---|
static java.util.Collection |
ALL_SET_OPERATIONS
All set operations, for all technologies.
|
static java.lang.String |
COMPONENT_TYPE_NAME
The component type name for this component.
|
static java.lang.String |
PROPKEY_SET_OP_TYPE
Property key name for the set operation type property.
|
static java.lang.String |
SET_OP_TYPE_EXCEPT
Supported by: IBM DB2 UDB, IBM DB2/400, Microsoft SQL Server, Oracle BI, PostgreSQL, Teradata
|
static java.lang.String |
SET_OP_TYPE_EXCEPT_ALL
Supported by: Derby, IBM DB2 UDB, Netezza, Oracle BI, PostgreSQL
|
static java.lang.String |
SET_OP_TYPE_EXCEPT_DISTINCT
Supported by: Derby, Netezza
|
static java.lang.String |
SET_OP_TYPE_INTERSECT
Set operation property value for "intersect" meaning that the output
row set will consist of all the rows from the input row sets that are
common between them.
Supported by: Attunity, HSQL, IBM DB2 UDB, IBM DB2/400, In-Memory Engine, Microsoft SQL Server, Oracle, Oracle BI, PostgreSQL, Teradata, TimesTen |
static java.lang.String |
SET_OP_TYPE_INTERSECT_ALL
Supported by: Derby, IBM DB2 UDB, Netezza, Oracle BI, PostgreSQL
|
static java.lang.String |
SET_OP_TYPE_INTERSECT_DISTINCT
Supported by: Derby, Netezza
|
static java.lang.String |
SET_OP_TYPE_MINUS
Supported by: Attunity, HSQL, In-Memory Engine, Oracle, Teradata, TimesTen
|
static java.lang.String |
SET_OP_TYPE_MINUS_ALL
Supported by: Netezza
|
static java.lang.String |
SET_OP_TYPE_MINUS_DISTINCT
Supported by: Netezza
|
static java.lang.String |
SET_OP_TYPE_UNION
Set operation property value for "union" meaning a union of all rows from
all inputs, but no duplicate rows.
Supported by: Attunity, BTrieve, Complex File, DBase, HSQL, IBM DB2 UDB, IBM DB2/400, In-Memory Engine, Informix, Ingres, Interbase, JMS Queue XML, JMS Topic XML, LDAP, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, Oracle BI, PostgreSQL, Progress, SAP ABAP, Sybase AS Anywhere, Sybase AS Enterprise, Sybase AS IQ, Teradata, TimesTen, Universe, XML |
static java.lang.String |
SET_OP_TYPE_UNION_ALL
Set operation property value for "union all" meaning a union of all rows from
all inputs, including duplicate rows.
Supported by: Attunity, BTrieve, Complex File, Derby, HSQL, IBM DB2 UDB, IBM DB2/400, In-Memory Engine, Informix, Interbase, JMS Queue XML, JMS Topic XML, LDAP, Microsoft Access, Microsoft SQL Server, MySQL, Netezza, Oracle, Oracle BI, PostgreSQL, Progress, SAP ABAP, Sybase AS Anywhere, Sybase AS Enterprise, Sybase AS IQ, Teradata, TimesTen, Universe, XML |
static java.lang.String |
SET_OP_TYPE_UNION_DISTINCT
Supported by: Derby, Netezza
|
VARIABLE_COMPONENT_TYPE_NAME
Constructor and Description |
---|
SetComponent(MapComponentOwner owner,
java.lang.String name)
Constructs a new persistent set component.
|
Modifier and Type | Method and Description |
---|---|
MapAttribute |
addSetAttribute(MapConnectorPoint scopingInputPoint,
java.lang.String name,
java.lang.String[] expressionTextArray)
Adds a new output attribute with a set of associated input expression strings.
|
MapAttribute |
addSetAttribute(java.lang.String name,
java.lang.String[] expressionTextArray)
Adds a new output attribute with a set of associated input expression strings.
|
void |
addSetAttributeExpression(MapAttribute pToAttribute,
MapAttribute fromAttr,
MapPathSpecifier path)
Adds the expression for this attribute and input point.
|
MapExpression |
addSetAttributeExpression(MapAttribute pSourceAttribute,
java.lang.String pTargetAttributeName,
java.lang.String pExpressionText,
IDataType pDataType,
java.lang.Integer size,
java.lang.Integer scale)
If the current set component owns an
MapAttribute of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint ,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType of this attribute.If the current set component owns an MapAttribute of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint ,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType of this attribute.If the current set component does not own a MapAttribute of the same name as pAttributeName,
then this method create a new attribute with pAttributeName as a name, pExpressionText as an expression
and pDataType as the datatype. |
void |
addSetAttributeExpression(MapConnectorPoint scopingInputPoint,
MapAttribute pToAttribute,
MapAttribute fromAttr,
MapPathSpecifier path)
Adds the expression for this attribute and input point.
|
MapExpression |
addSetAttributeExpression(MapConnectorPoint pScopingInputPoint,
MapAttribute pSourceAttribute,
java.lang.String pTargetAttributeName,
java.lang.String pExpressionText,
IDataType pDataType,
java.lang.Integer size,
java.lang.Integer scale)
If the current set component owns an
MapAttribute of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint ,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType of this attribute.If the current set component owns an MapAttribute of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint ,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType of this attribute.If the current set component does not own a MapAttribute of the same name as pAttributeName,
then this method create a new attribute with pAttributeName as a name, pExpressionText as an expression
and pDataType as the datatype. |
void |
addSetExpression(java.lang.String attributeName,
java.lang.String expressionText,
MapConnectorPoint pScopingInputPoint)
Adds an expression to the specified attribute of the set component, based on the cross references computed on the expression text.
|
void |
addSetExpression(java.lang.String attributeName,
java.lang.String expressionText,
java.lang.String pScopingInputPointName)
Adds an expression to the specified attribute of the set component, based on the cross references computed on the expression text.
|
void |
addToSet(IMapComponent source)
Convenience method to add an extra source to an existing set operator.
|
MapConnectorPoint |
createInputConnectorPoint(java.lang.String name)
Adds an input connector point with the specified name if there are no remaining unconnected
input connector points, otherwise an existing unconnected input connector point is renamed and returned.
|
static IMapComponent |
createSet(IMapComponent source1,
IMapComponent source2,
java.lang.String setOpType)
Convenience method to create a set component and connect to sources to it.
|
static SetComponent |
createSet(java.lang.String setName,
IMapComponent source1,
IMapComponent source2,
java.lang.String setOpType,
IMapComponent[] sources)
Convenience method to create a set component and connect two sources to it.
|
static SetComponent |
createSet(java.lang.String setName,
java.lang.String setOpType,
IMapComponent[] sources)
Convenience method to create a set component and connect sources to it.
|
java.util.List |
getSetAttributes()
Returns the attributes for the first output connector
|
java.lang.String |
getSetOperationType(MapConnectorPoint inputConnectorPoint)
Gets the set operation type for the specified input point of the set component.
|
java.lang.String |
getSetOperationType(java.lang.String inputConnectorPointName)
Gets the set operation type for the specified input point of the set component.
|
void |
setSetOperationType(MapConnectorPoint inputConnectorPoint,
java.lang.String opType)
Sets the operation type property for the specified input connector point of this component.
|
customSyncComponent, fixExpressions, getBlockExpressionReferencedAttributes, getExecuteOnHintString, getIntegrationType, getNextAvailableInput, getNextAvailableInput, getNextAvailableOutput, invalidateExpressions, isAddInputConnectorPointAllowed, isAddOutputConnectorPointAllowed, isPassive, setExecuteOnHintByString
afterAddComponent, afterPropertyChange, afterRemoveComponent, allowInputAttribute, connectFrom, createInputConnectorPoint, createOutputConnectorPoint, createOutputConnectorPoint, customValidateProposedChildConnection, customValidateProposedChildScoping, equals, getBoundObjectFullName, getBoundObjectName, getBoundShortcutFullName, getComponentContext, getComponentCustomLocation, getComponentType, getInScopeAttributeXMap, getSQLAccessName, getTechnicalDescription, getTypeName, handleChildMapChangeEvent, hashCode, initPhysicalNode, isBoundObjectDeleted, isCompositeComponentType, notifyPropertyChange, setComponentType, supportComponentOfType, toString, validateReorderComponent
addComponent, addProperty, afterConnect, bindTo, bindTo, connectTo, connectTo, connectTo, connectTo, containsComponent, createComponent, createComponent, createComponent, createExpressionAttribute, createExpressionAttribute, createOutputConnectorPoint, createProperty, dump, dump, findAllComponents, findAllSplitPaths, findComponent, findComponentBoundTo, findComponentOfType, findConnector, findConnectorPoint, findInputAttribute, findOutputAttribute, findSubComponentOwner, generateUniqueComponentName, generateUniqueComponentName, generateUniqueConnectorName, generateUniqueName, generateUniqueName, getAdapter, getAllComponents, getAllComponentsOfType, getAllExpressions, getAllPathsFrom, getAllPathsFrom, getAllProperties, getAllSubComponentOwners, getAttributeExpressions, getAttributes, getBooleanPropertyValue, getBoundObject, getBoundShortcut, getBoundTechnology, getBusinessName, getCachedIssues, getComponentAttributeMap, getComponentCategory, getComponentCount, getComponentLocation, getComponentOwner, getComponents, getComponentTypeName, getCompositeQualifier, getConnectorPointCount, getConnectorPointCount, getConnectorPoints, getConnectorPoints, getConnectorPointToLeaf, getConnectorTo, getDelegate, getDescription, getDisplayableObjectName, getDisplayableProperties, getDisplayableTypeName, getDomainInterfaceType, getDownstreamConnectedLeafComponents, getDownstreamConnectedPoints, getExpressionPropertyValue, getExpressionReferences, getExpressionValidationCode, getExtraCreatedObjects, getFlowConstraints, getFullName, getGlobalId, getGUID, getInputConnectorPoint, getInputConnectorPoint, getInputConnectorPointCount, getInputConnectorPoints, getInputPoint, getInScopeAttributes, getInScopeAttributeXMap, getInternalId, getIntPropertyValue, getLeafLevelComponents, getLeafLevelTargets, getMapRootContainer, getName, getNumericId, getOutputAttributeExpressions, getOutputAttributes, getOutputConnectorPoint, getOutputConnectorPoint, getOutputConnectorPointCount, getOutputConnectorPoints, getOutputPoint, getOwner, getOwningComponent, getPersistentClassName, getPersistentComponent, getPrefix, getProjectedAttributes, getProjectorOrMultiInputSource, getProperties, getProperty, getPropertyDefinitionOwner, getPropertyValue, getPropertyValueReference, getProposedConnectionIssues, getProposedConnectionIssues, getProposedScopingIssues, getQualifiedName, getRootComponentOwner, getRootContainer, getScopingInputPointForSource, getSecurityContainer, getSources, getStringPropertyValue, getStrongTypeClassName, getSyncState, getTargets, getTopLevelComponentsOfType, getTopLevelSources, getTopLevelTargets, getTopmostComponent, getUpstreamAttributeXMap, getUpstreamComponentOwner, getUpstreamConnectedLeafComponents, getUpstreamConnectedLeafPoints, getUpstreamConnectedPoints, getUpstreamInScopeLeafAttributes, getUpstreamInScopeLeafComponentsFor, getUpstreamInScopeLeafPoints, getUpstreamLeafAttributes, getUpstreamLeafAttributes, getUpstreamLeafConnectorPoints, getUpstreamLeafSources, getUpstreamSources, getUpstreamSplitPaths, hasCustomizedPersistenceMethodFor, invalidateDownstreamExpressions, invokeCustomizedPersistenceMethodFor, invokeMethod, isBound, isComponent, isComponentLevelConnectAllowed, isCompositeComponent, isDecorator, isEndpoint, isHidden, isInScope, isInScope, isMultiInputSelector, isOfType, isProjector, isPropertyDefined, isProposedConnectionValid, isProposedConnectionValid, isProposedScopingValid, isSelector, isSource, isSubComponent, isTarget, isUniqueComponentName, isUniqueComponentName, referencesObject, removeAllConnections, removeAllConnections, removeAllConnectionsAndReroute, removeAllConnectionsAndReroute, removeAllInputConnections, removeComponent, removeComponent, removeInputConnectorPoint, removeInputConnectorPoint, removeInputConnectorPoint, removeOutputConnectorPoint, removeOutputConnectorPoint, removeProperty, reorderInputConnectorPoint, reorderOutputConnectorPoint, rerouteConnections, setAlias, setAttributeExpressionText, setAttributeExpressionText, setBooleanPropertyValue, setBusinessName, setDescription, setIntPropertyValue, setIsHidden, setName, setPropertyValue, syncComponent, validate, validate, validateProperties
public static final java.lang.String COMPONENT_TYPE_NAME
public static final java.lang.String PROPKEY_SET_OP_TYPE
public static final java.lang.String SET_OP_TYPE_UNION_ALL
public static final java.lang.String SET_OP_TYPE_UNION
public static final java.lang.String SET_OP_TYPE_MINUS
public static final java.lang.String SET_OP_TYPE_UNION_DISTINCT
public static final java.lang.String SET_OP_TYPE_EXCEPT_DISTINCT
public static final java.lang.String SET_OP_TYPE_EXCEPT_ALL
public static final java.lang.String SET_OP_TYPE_INTERSECT_DISTINCT
public static final java.lang.String SET_OP_TYPE_INTERSECT_ALL
public static final java.lang.String SET_OP_TYPE_INTERSECT
public static final java.lang.String SET_OP_TYPE_EXCEPT
public static final java.lang.String SET_OP_TYPE_MINUS_DISTINCT
public static final java.lang.String SET_OP_TYPE_MINUS_ALL
public static java.util.Collection ALL_SET_OPERATIONS
public SetComponent(MapComponent component) throws MappingException
component
- oracle.odi.domain.mapping.exception.MapComponentException
MappingException
public SetComponent(MapComponentType componentType) throws oracle.odi.domain.mapping.exception.MapComponentException
componentType
- oracle.odi.domain.mapping.exception.MapComponentException
public SetComponent(MapComponentOwner owner, java.lang.String name) throws MappingException, AdapterException
owner
- The component owner that will own the new component.name
- The name for the new component.PropertyException
oracle.odi.domain.mapping.exception.MapComponentException
AdapterException
MappingException
public MapConnectorPoint createInputConnectorPoint(java.lang.String name) throws MappingException
createInputConnectorPoint
in class oracle.odi.domain.mapping.MapComponentDelegate
name
- name of the connector pointoracle.odi.domain.mapping.exception.MapComponentException
PropertyException
MappingException
public java.util.List getSetAttributes() throws MappingException, AdapterException
MapAttribute
oracle.odi.domain.mapping.exception.MapComponentException
PropertyException
AdapterException
MappingException
public MapAttribute addSetAttribute(java.lang.String name, java.lang.String[] expressionTextArray) throws MappingException, AdapterException
name
- new attribute nameexpressionTextArray
- array of expressions, with the array order matching the input connector point order.MapAttribute
AdapterException
oracle.odi.domain.mapping.exception.MapComponentException
- if multiple expression texts of expresionTextArray reference the same connector point.MappingException
public MapAttribute addSetAttribute(MapConnectorPoint scopingInputPoint, java.lang.String name, java.lang.String[] expressionTextArray) throws MappingException, AdapterException
scopingInputPoint
- optional input point which may be specified if an expression has no cross referencesname
- new attribute nameexpressionTextArray
- array of expressions, with the array order matching the input connector point order.MapAttribute
AdapterException
oracle.odi.domain.mapping.exception.MapComponentException
- if multiple expression texts of expresionTextArray reference the same connector point.MappingException
public void addSetAttributeExpression(MapAttribute pToAttribute, MapAttribute fromAttr, MapPathSpecifier path) throws MappingException, AdapterException
pToAttribute
- set component attribute to build the expression forfromAttr
- source attribute, used to form the expression for the attribute and input pointpath
- path specification, used to determine the scopingInputPoint for the expression.MappingException
AdapterException
public void addSetAttributeExpression(MapConnectorPoint scopingInputPoint, MapAttribute pToAttribute, MapAttribute fromAttr, MapPathSpecifier path) throws MappingException, AdapterException
scopingInputPoint
- the input point which determines which expression to set for the attribute (an attribute
will have an expression for each input point). If this value is null, the path parameter may be used.pToAttribute
- set component attribute to build the expression forfromAttr
- source attribute, used to form the expression for the attribute and input pointpath
- path specification, used to determine the scopingInputPoint if it is nullMappingException
AdapterException
public void addSetExpression(java.lang.String attributeName, java.lang.String expressionText, java.lang.String pScopingInputPointName) throws oracle.odi.domain.mapping.exception.MapComponentException, PropertyException, oracle.odi.domain.mapping.expression.parser.ExpressionParseException, AdapterException, MappingException
If the expression text refers to a scoping input point already defined for this attribute, it updates the text of the expression for this scoping input point.
Otherwise, it creates a new expression for this scoping input point.
attributeName
- Set component attribute on which the expression will be addedexpressionText
- Text of the expression to addpScopingInputPointName
- name of the scoping input point for this expressionoracle.odi.domain.mapping.exception.MapComponentException
PropertyException
oracle.odi.domain.mapping.expression.parser.ExpressionParseException
AdapterException
MappingException
public void addSetExpression(java.lang.String attributeName, java.lang.String expressionText, MapConnectorPoint pScopingInputPoint) throws MappingException, AdapterException
If the expression text refers to a scoping input point already defined for this attribute, it updates the text of the expression for this scoping input point.
Otherwise, it creates a new expression for this scoping input point.
attributeName
- Set component attribute on which the expression will be addedexpressionText
- Text of the expression to addpScopingInputPoint
- Scoping input point for this expressionoracle.odi.domain.mapping.exception.MapComponentException
PropertyException
oracle.odi.domain.mapping.expression.parser.ExpressionParseException
AdapterException
MappingException
public MapExpression addSetAttributeExpression(MapAttribute pSourceAttribute, java.lang.String pTargetAttributeName, java.lang.String pExpressionText, IDataType pDataType, java.lang.Integer size, java.lang.Integer scale) throws MappingException, AdapterException
MapAttribute
of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint
,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType
of this attribute.MapAttribute
of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint
,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType
of this attribute.MapAttribute
of the same name as pAttributeName,
then this method create a new attribute with pAttributeName as a name, pExpressionText as an expression
and pDataType as the datatype.pSourceAttribute
- source attribute, used to create the expression.pTargetAttributeName
- the name of the attribute to create or update. Must not be null or empty.pExpressionText
- the text of the expression for this attribute. Must not be null.pDataType
- the datatype of the attribute to create or the datatype of the updated attribute must be. Must not be null.size
- The size of the attribute to create (if any).scale
- The scale of the attribute to create (if any).oracle.odi.domain.mapping.exception.MapComponentException
PropertyException
AdapterException
oracle.odi.domain.mapping.expression.parser.ExpressionParseException
MappingException
public MapExpression addSetAttributeExpression(MapConnectorPoint pScopingInputPoint, MapAttribute pSourceAttribute, java.lang.String pTargetAttributeName, java.lang.String pExpressionText, IDataType pDataType, java.lang.Integer size, java.lang.Integer scale) throws MappingException, AdapterException
MapAttribute
of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint
,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType
of this attribute.MapAttribute
of the same name as pAttributeName
and if this attribute owns an expression linked to the same MapConnectorPoint
,
then this method will replace the expression with pExpressionText if the pDatatype matches
the current IDataType
of this attribute.MapAttribute
of the same name as pAttributeName,
then this method create a new attribute with pAttributeName as a name, pExpressionText as an expression
and pDataType as the datatype.pScopingInputPoint
- If non-null, specifies the scoping input point to be associated with the new expression.pSourceAttribute
- source attribute used to create the expression.pTargetAttributeName
- the name of the attribute to create or update. Must not be null or empty.pExpressionText
- the text of the expression for this attribute. Must not be null.pDataType
- the datatype of the attribute to create or the datatype of the updated attribute must be. Must not be null.size
- The size of the attribute to create (if any).scale
- The scale of the attribute to create (if any).oracle.odi.domain.mapping.exception.MapComponentException
PropertyException
AdapterException
oracle.odi.domain.mapping.expression.parser.ExpressionParseException
MappingException
public void setSetOperationType(MapConnectorPoint inputConnectorPoint, java.lang.String opType) throws PropertyException
inputConnectorPoint
- connector point to set the operation type for.opType
- The operation type property value for the set operator. Must be one
of the valid values defined in this delegate class, for example, SET_OP_TYPE_UNIONPropertyException
- if inputConnectorPoint is the first connector point.public java.lang.String getSetOperationType(MapConnectorPoint inputConnectorPoint) throws PropertyException
inputConnectorPoint
- input point to get the operation type for.PropertyException
- if inputConnectorPoint is the first connector point.public java.lang.String getSetOperationType(java.lang.String inputConnectorPointName) throws PropertyException, oracle.odi.domain.mapping.exception.MapComponentException
inputConnectorPointName
- input point to get the operation type for.PropertyException
- if inputConnectorPoint is the first connector point.oracle.odi.domain.mapping.exception.MapComponentException
public static SetComponent createSet(java.lang.String setName, IMapComponent source1, IMapComponent source2, java.lang.String setOpType, IMapComponent[] sources) throws MappingException, AdapterException
setName
- The name of the set operator to be created. must not be null or empty string.setOpType
- The set operation type, which is defined on the input point for source2.sources
- The set of source components to connect to the set.PropertyException
oracle.odi.domain.mapping.exception.MapComponentException
AdapterException
MappingException
public static SetComponent createSet(java.lang.String setName, java.lang.String setOpType, IMapComponent[] sources) throws MappingException, AdapterException
setName
- The name of the set operator to be created. must not be null or empty string.setOpType
- The set operation type, which is defined on the input point for source2.sources
- The set of source components to connect to the set.PropertyException
oracle.odi.domain.mapping.exception.MapComponentException
AdapterException
MappingException
public static IMapComponent createSet(IMapComponent source1, IMapComponent source2, java.lang.String setOpType) throws MappingException, AdapterException
source1
- The first source to connect to the set.source2
- The second source to connect to the set.setOpType
- The set operation type, which is defined on the input point for source2.PropertyException
oracle.odi.domain.mapping.exception.MapComponentException
AdapterException
MappingException
public void addToSet(IMapComponent source) throws MappingException
source
- The source to be added to the set operator.oracle.odi.domain.mapping.exception.MapComponentException
PropertyException
MappingException