Oracle® Data Integrator Java API Reference
11g Release 1 (11.1.1.3.0)

E17060-01

oracle.odi.domain.project.interfaces
Class TargetColumn

java.lang.Object
  extended by oracle.odi.domain.support.BusinessObject
      extended by oracle.odi.domain.support.AbstractRepositoryEntity
          extended by oracle.odi.domain.project.interfaces.TargetColumn
All Implemented Interfaces:
java.io.Serializable, java.lang.Cloneable, IRepositoryEntity, IInterfaceSubComponent, IOptionnallyPersistedObject, IColumn<OdiInterface.TargetDataStore>

public class TargetColumn
extends oracle.odi.domain.support.AbstractRepositoryEntity
implements IInterfaceSubComponent, IColumn<OdiInterface.TargetDataStore>, IOptionnallyPersistedObject

A target column is a column of a OdiInterface.TargetDataStore in an OdiInterface.
It contains information about how the column is mapped (indicators, potentially a target SQL mapping text).
When the target datastore has an underlying OdiDataStore, each TargetMapping points to one OdiColumn of this OdiDataStore.
In this case, TargetColumns are persisted according to an IMappingPersistencePolicy for obvious performance reasons (on a target datastore with 500 columns on which only 10 columns are mapped, this can make a difference).
On temporary target datastores, target columns do not reflect an OdiColumn and are systematically persisted.
Note that all setters in this class should not be used directly. To create, modify or delete a target column of an OdiInterface, use IInterfaceActions on an IInteractiveInterfaceHelperWithActions.

Since:
11.1.1.3.0
See Also:
OdiInterface.TargetDataStore, TargetMapping, IMappingPersistencePolicy, Serialized Form

Constructor Summary
TargetColumn(OdiInterface pParentInterface, OdiColumn pRealColumn, OdiInterface.ExecutionLocation pExecutionLocation)
          Internal use only Creates a new target column object.
TargetColumn(OdiInterface pParentInterface, OdiInterface.ExecutionLocation pExecutionLocation)
          Internal use only Creates a new target column object.
TargetColumn(OdiInterface pParentInterface, java.lang.String pName, OdiInterface.ExecutionLocation pExecutionLocation)
          Internal use only Creates a new target column object.
 
Method Summary
 void addTargetMapping(TargetMapping pTargetMapping)
          Internal use only Adds a target mapping to this target column.
 void changeToTemporaryColumn()
          Internal use only Modifies an existing target column for use when the target datastore is changed to temporary.
 java.lang.String getBusinessRule()
          Returns the business rule of this target column.
The business rule is a custom functional description of what this column represents.
 OdiDataType getDataType()
          Returns the datatype of this target column.
 OdiInterface.ExecutionLocation getExecutionLocation()
          Returns the location of the execution of the mapping, if any.
If no mapping is set for this target column, null is returned.
If this column is mapped on the target then OdiInterface.ExecutionLocation.TARGET is returned.
If this column is mapped on the Staging Area or on Source, then null is returned, you will need to fetch the execution location for each DataSet on the corresponding TargetMappings, either by fetching them from getTargetMappings() either from DataSet.getMapping(String).
 java.io.Serializable getInternalId()
          The internal ID of this sub component.
Returning null from this method will indicate the object has never been persisted in the repository.
 java.lang.Integer getInternalLength()
          Returns the length of the column.
Unlike getLength(), this method will return null rather than throwing an exception if the length is not allowed.
 java.lang.Integer getInternalScale()
          Returns the scale of the column.
Unlike getScale(), this method will return null rather than throwing an exception if the scale is not allowed.
 java.lang.Integer getLength()
          Returns the length of the column.
If the datatype is not set or doesn't allow length, a call to this method will cause an IllegalStateException.
 java.lang.String getName()
          Returns the name of the target column.
 Expression getNonPersistedSql()
          Returns the non persisted expression on this target column.
The difference between the persisted and non persisted versions lie in the cross-references, as some cross-references are not persisted in the repository.
 OdiInterface getParentInterface()
          Returns the parent interface of this target column.
 java.lang.Integer getScale()
          Returns the scale of the column.
If the datatype is not set or doesn't allow scale, a call to this method will cause an IllegalStateException.
 IRepositoryEntity getSecurityContainer()
          Define a generic way to retrieve container for entities.
 java.lang.String getSubComponentDescription()
          Returns the sub component's description in a human-readable way.
 java.lang.String getSubComponentDescription(java.util.Locale pLocale)
          Returns the sub component's description in a human-readable way for the given Locale.
 OdiInterface.TargetDataStore getTable()
          Returns the target datastore of the interface owning this target column.
 java.lang.Number getTargetColumnId()
          Returns the target column's ID in the repository.
 java.util.Collection<TargetMapping> getTargetMappings()
          Returns all target mappings for this target column.
When the target column is mapped and is not executed on TARGET, then there is one mapping for each DataSet.
 java.lang.String getTargetSql()
          Returns the target mapping as a String for mappings executed on the target.
 Expression getTargetSqlMappingExpression()
          When the mapping on this TargetColumn is executed on TARGET, obtains the SQL mapping for this column.
 java.lang.Number getTargetSqlMappingExpressionId()
          Returns the ID of the target expression for the mapping when executed on the target.
 OdiColumn getUnderlyingOdiColumn()
          The underlying OdiColumn.
If the TargetDataStore is a temporary datastore, null is returned as there is no underlying OdiColumn.
 void initializeMappingsFromPersisted()
          Internal use only Initialize internal persistence mapping.
 boolean isCheckNotNullIndicator()
          If true then the column will be checked for not null during the loading of the data in the target datastore.
For this to happen, you need to have a CKM defined on the interface and to make sure that the IKM is enabled for flow control (please refer to the documentation of the IKM).
Additionally, you may want to make sure that flow control and/or static control are enabled on the OdiColumn in the model if the datastore is not temporary.
 boolean isEnable()
          Returns whether this target column is mapped or not.
 boolean isInsertIndicator()
          Returns whether this column is tagged for insert.
 boolean isPersisted()
          Returns whether this object should be persisted in the repository or not.
 boolean isTemporaryColumn()
          Returns whether this is a temporary column.
true means that this column has no underlying OdiColumn.
 boolean isUpdateIndicator()
          Returns whether this column is tagged for update.
 boolean isUpdateKeyIndicator()
          Returns whether this column will be used as key when doing updates on the target datastore.
 boolean isUserDefinedIndicator1()
          Returns whether this column has the User Defined Indicator 1 set.
 boolean isUserDefinedIndicator10()
          Returns whether this column has the User Defined Indicator 10 set.
 boolean isUserDefinedIndicator2()
          Returns whether this column has the User Defined Indicator 2 set.
 boolean isUserDefinedIndicator3()
          Returns whether this column has the User Defined Indicator 3 set.
 boolean isUserDefinedIndicator4()
          Returns whether this column has the User Defined Indicator 1 set.
 boolean isUserDefinedIndicator5()
          Returns whether this column has the User Defined Indicator 5 set.
 boolean isUserDefinedIndicator6()
          Returns whether this column has the User Defined Indicator 6 set.
 boolean isUserDefinedIndicator7()
          Returns whether this column has the User Defined Indicator 7 set.
 boolean isUserDefinedIndicator8()
          Returns whether this column has the User Defined Indicator 8 set.
 boolean isUserDefinedIndicator9()
          Returns whether this column has the User Defined Indicator 9 set.
 void populatePersistedMappings()
          Internal use only Populate internal persistence mapping.
 void removeTargetMapping(TargetMapping pTargetMapping)
          Internal use only Removes a target mapping from this target column.
 void setBusinessRule(java.lang.String pBusinessRule)
          Internal use only Sets the business rule for this target column.
Use InterfaceActionOnTargetColumnSetBusinessRule to set this property.
 void setCheckNotNullIndicator(boolean pCheckNotNullIndicator)
          Internal use only
Sets a new value for the check not null indicator.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the indicator type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.CHECK_NOT_NULL.
 void setDataType(OdiDataType pOdiDataType)
          Internal use only Sets the data type of the target column.
 void setEnable(boolean pEnable)
          Internal use only Mapped columns need to have a mapping SQL expression set, which will be executed either on target, either on the Staging Area or on the Source.
 void setExecutionLocation(OdiInterface.ExecutionLocation pExecutionLocation)
          Internal use only Sets the execution location for this target column.
To set the execution location on target columns, use InterfaceActionOnTargetMappingSetLocation.
 void setInsertIndicator(boolean pInsertIndicator)
          Internal use only Sets whether this column will participate in insert operations.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.INSERT.
 void setLength(java.lang.Integer pLength)
          Internal use only Sets the length of the column.
 void setName(java.lang.String pName)
          For internal use only Sets the name of the target column.
 void setPersisted(boolean pPersisted)
          Internal use only Sets whether the target column is persisted.
 void setScale(java.lang.Integer pScale)
          Internal use only Sets the scale of the target column.
 void setTargetSqlMappingExpression(Expression pTargetSQLMapping)
          Internal use only Sets the mapping expression to be executed on target on this target column.
To set this property, use InterfaceActionOnTargetMappingSetSql with a null DataSet (provided that you really want to set a mapping on the target).
Note that mappings should comply with a few basic rules:
- mappings executed on the SOURCE should not reference columns from different physical schemas,
- mappings executed on the SOURCE should reference at least a source column, otherwise the target column should be manually assigned to a SourceDataStore using InterfaceActionOnTargetMappingSetAttachedDataStore,
- mappings executed on the TARGET should not reference any source columns, since the source columns are not available on the target.
 void setUnderlyingOdiColumn(OdiColumn pColumn)
          Internal use only Sets the underlying column for this target column.
 void setUpdateIndicator(boolean pUpdateIndicator)
          Internal use only Sets whether this column will participate in Update operations.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.UPDATE.
 void setUpdateKeyIndicator(boolean pUpdateKeyIndicator)
          Internal use only Sets whether this column will be used as key when doing updates on the target datastore.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.UPDATE_KEY.
 void setUserDefinedIndicator1(boolean pUserDefinedIndicator1)
          Internal use only Sets whether this column has the User Defined Indicator 1 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=1.
 void setUserDefinedIndicator10(boolean pUserDefinedIndicator10)
          Internal use only Sets whether this column has the User Defined Indicator 10 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=10.
 void setUserDefinedIndicator2(boolean pUserDefinedIndicator2)
          Internal use only Sets whether this column has the User Defined Indicator 2 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=2.
 void setUserDefinedIndicator3(boolean pUserDefinedIndicator3)
          Internal use only Sets whether this column has the User Defined Indicator 3 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=3.
 void setUserDefinedIndicator4(boolean pUserDefinedIndicator4)
          Internal use only Sets whether this column has the User Defined Indicator 4 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=4.
 void setUserDefinedIndicator5(boolean pUserDefinedIndicator5)
          Internal use only Sets whether this column has the User Defined Indicator 5 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=5.
 void setUserDefinedIndicator6(boolean pUserDefinedIndicator6)
          Internal use only Sets whether this column has the User Defined Indicator 6 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=6.
 void setUserDefinedIndicator7(boolean pUserDefinedIndicator7)
          Internal use only Sets whether this column has the User Defined Indicator 7 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=7.
 void setUserDefinedIndicator8(boolean pUserDefinedIndicator8)
          Internal use only Sets whether this column has the User Defined Indicator 8 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=8.
 void setUserDefinedIndicator9(boolean pUserDefinedIndicator9)
          Internal use only Sets whether this column has the User Defined Indicator 9 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=9.
 
Methods inherited from class oracle.odi.domain.support.BusinessObject
clone
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

TargetColumn

public TargetColumn(OdiInterface pParentInterface,
                    OdiColumn pRealColumn,
                    OdiInterface.ExecutionLocation pExecutionLocation)
Internal use only Creates a new target column object.

Parameters:
pParentInterface - the parent interface of this column
pRealColumn - the real underlying OdiColumn
pExecutionLocation - the execution location for the mapping of this column

TargetColumn

public TargetColumn(OdiInterface pParentInterface,
                    OdiInterface.ExecutionLocation pExecutionLocation)
Internal use only Creates a new target column object.

Parameters:
pParentInterface - the parent interface of this column
pExecutionLocation - the execution location for the mapping of this column

TargetColumn

public TargetColumn(OdiInterface pParentInterface,
                    java.lang.String pName,
                    OdiInterface.ExecutionLocation pExecutionLocation)
Internal use only Creates a new target column object.

Parameters:
pParentInterface - the parent interface of this column
pName - the name for this temporary column
pExecutionLocation - the execution location for the mapping of this column
Method Detail

addTargetMapping

public void addTargetMapping(TargetMapping pTargetMapping)
Internal use only Adds a target mapping to this target column.

Parameters:
pTargetMapping - the new target mapping for this column

changeToTemporaryColumn

public void changeToTemporaryColumn()
Internal use only Modifies an existing target column for use when the target datastore is changed to temporary.


getBusinessRule

public java.lang.String getBusinessRule()
Returns the business rule of this target column.
The business rule is a custom functional description of what this column represents.

Returns:
the business rule of this target column
See Also:
setBusinessRule(String)

getDataType

public OdiDataType getDataType()
Returns the datatype of this target column.

Specified by:
getDataType in interface IColumn<OdiInterface.TargetDataStore>
Returns:
the datatype of this target column.
See Also:
IColumn.getDataType(), setDataType(OdiDataType)

getExecutionLocation

public OdiInterface.ExecutionLocation getExecutionLocation()
Returns the location of the execution of the mapping, if any.
If no mapping is set for this target column, null is returned.
If this column is mapped on the target then OdiInterface.ExecutionLocation.TARGET is returned.
If this column is mapped on the Staging Area or on Source, then null is returned, you will need to fetch the execution location for each DataSet on the corresponding TargetMappings, either by fetching them from getTargetMappings() either from DataSet.getMapping(String).

Returns:
the execution location of the target column. null indicates that this column is either not mapped at all, either not executed on the TARGET
See Also:
setExecutionLocation(oracle.odi.domain.project.OdiInterface.ExecutionLocation), setExecutionLocation(OdiInterface.ExecutionLocation)

getInternalId

public java.io.Serializable getInternalId()
Description copied from interface: IInterfaceSubComponent
The internal ID of this sub component.
Returning null from this method will indicate the object has never been persisted in the repository.

Specified by:
getInternalId in interface IRepositoryEntity
Specified by:
getInternalId in interface IInterfaceSubComponent
Returns:
the persistence identity of this instance

getInternalLength

public java.lang.Integer getInternalLength()
Returns the length of the column.
Unlike getLength(), this method will return null rather than throwing an exception if the length is not allowed.

Returns:
the length of the column

getInternalScale

public java.lang.Integer getInternalScale()
Returns the scale of the column.
Unlike getScale(), this method will return null rather than throwing an exception if the scale is not allowed.

Returns:
the scale of the column

getLength

public java.lang.Integer getLength()
Returns the length of the column.
If the datatype is not set or doesn't allow length, a call to this method will cause an IllegalStateException.

Specified by:
getLength in interface IColumn<OdiInterface.TargetDataStore>
Returns:
column's length
Throws:
java.lang.IllegalStateException - if the OdiDataType of this column is not set or doesn't allow length
See Also:
IColumn.getLength(), setLength(Integer), setLength(Integer)

getName

public java.lang.String getName()
Returns the name of the target column.

Specified by:
getName in interface IColumn<OdiInterface.TargetDataStore>
Returns:
the name of the target column.
See Also:
IColumn.getName(), setName(String)

getNonPersistedSql

public Expression getNonPersistedSql()
Returns the non persisted expression on this target column.
The difference between the persisted and non persisted versions lie in the cross-references, as some cross-references are not persisted in the repository.

Returns:
the non persisted expression on this target column.

getParentInterface

public OdiInterface getParentInterface()
Returns the parent interface of this target column.

Returns:
the parent interface of this target column

getScale

public java.lang.Integer getScale()
Returns the scale of the column.
If the datatype is not set or doesn't allow scale, a call to this method will cause an IllegalStateException.

Specified by:
getScale in interface IColumn<OdiInterface.TargetDataStore>
Returns:
column' scale
Throws:
java.lang.IllegalStateException - if the OdiDataType of this column is not set or doesn't allow scale
See Also:
IColumn.getScale(), setScale(Integer), setScale(Integer)

getSecurityContainer

public IRepositoryEntity getSecurityContainer()
Description copied from interface: IRepositoryEntity
Define a generic way to retrieve container for entities.

Specified by:
getSecurityContainer in interface IRepositoryEntity
Returns:
container entity

getSubComponentDescription

public java.lang.String getSubComponentDescription()
Description copied from interface: IInterfaceSubComponent
Returns the sub component's description in a human-readable way.

Specified by:
getSubComponentDescription in interface IInterfaceSubComponent
Returns:
a human-readable String giving all necessary information to identify this component

getSubComponentDescription

public java.lang.String getSubComponentDescription(java.util.Locale pLocale)
Description copied from interface: IInterfaceSubComponent
Returns the sub component's description in a human-readable way for the given Locale.

Specified by:
getSubComponentDescription in interface IInterfaceSubComponent
Parameters:
pLocale - the Locale for which the description should be returned
Returns:
a human-readable String giving all necessary information to identify this component in the given Locale

getTable

public OdiInterface.TargetDataStore getTable()
Returns the target datastore of the interface owning this target column.

Specified by:
getTable in interface IColumn<OdiInterface.TargetDataStore>
Returns:
the target datastore of the interface owning this target column.
See Also:
IColumn.getTable()

getTargetColumnId

public java.lang.Number getTargetColumnId()
Returns the target column's ID in the repository.

Returns:
the target column's ID in the repository.

getTargetMappings

public java.util.Collection<TargetMapping> getTargetMappings()
Returns all target mappings for this target column.
When the target column is mapped and is not executed on TARGET, then there is one mapping for each DataSet.

Returns:
the target mappings for this target column
See Also:
addTargetMapping(TargetMapping), removeTargetMapping(TargetMapping), DataSet.getMapping(String)

getTargetSql

public java.lang.String getTargetSql()
Returns the target mapping as a String for mappings executed on the target. Similar to getTargetSqlMappingExpression().getAsString() (when the expression is not null).

Returns:
the target mapping as a String
See Also:
getTargetSqlMappingExpression()

getTargetSqlMappingExpression

public Expression getTargetSqlMappingExpression()
When the mapping on this TargetColumn is executed on TARGET, obtains the SQL mapping for this column.

Returns:
the expression of the mapping for this target column. If the expression is not executed on OdiInterface.ExecutionLocation.TARGET, then returns null
See Also:
setTargetSqlMappingExpression(Expression)

getTargetSqlMappingExpressionId

public java.lang.Number getTargetSqlMappingExpressionId()
Returns the ID of the target expression for the mapping when executed on the target.

Returns:
the ID of the target expression for the mapping when executed on the target

getUnderlyingOdiColumn

public OdiColumn getUnderlyingOdiColumn()
The underlying OdiColumn.
If the TargetDataStore is a temporary datastore, null is returned as there is no underlying OdiColumn.

Returns:
The underlying OdiColumn reference, null on temporary target columns
See Also:
setUnderlyingOdiColumn(OdiColumn)

initializeMappingsFromPersisted

public void initializeMappingsFromPersisted()
Internal use only Initialize internal persistence mapping.


isCheckNotNullIndicator

public boolean isCheckNotNullIndicator()
If true then the column will be checked for not null during the loading of the data in the target datastore.
For this to happen, you need to have a CKM defined on the interface and to make sure that the IKM is enabled for flow control (please refer to the documentation of the IKM).
Additionally, you may want to make sure that flow control and/or static control are enabled on the OdiColumn in the model if the datastore is not temporary.

Returns:
whether this column should be checked for not null
See Also:
setCheckNotNullIndicator(boolean)

isEnable

public boolean isEnable()
Returns whether this target column is mapped or not.

Returns:
true if this target column is mapped, false otherwise
See Also:
setEnable(boolean)

isInsertIndicator

public boolean isInsertIndicator()
Returns whether this column is tagged for insert.

Returns:
true if this column will participate in inserts, false otherwise
See Also:
setInsertIndicator(boolean)

isPersisted

public boolean isPersisted()
Description copied from interface: IOptionnallyPersistedObject
Returns whether this object should be persisted in the repository or not.

Specified by:
isPersisted in interface IOptionnallyPersistedObject
Returns:
true if this object should be persisted, false otherwise

isTemporaryColumn

public boolean isTemporaryColumn()
Returns whether this is a temporary column.
true means that this column has no underlying OdiColumn.

Returns:
true if this TargetColumn is a temporary column

isUpdateIndicator

public boolean isUpdateIndicator()
Returns whether this column is tagged for update.

Returns:
true if this column will participate in updates, false otherwise
See Also:
setUpdateIndicator(boolean)

isUpdateKeyIndicator

public boolean isUpdateKeyIndicator()
Returns whether this column will be used as key when doing updates on the target datastore.

Returns:
true if this column will participate in the update key, false otherwise
See Also:
setUpdateKeyIndicator(boolean)

isUserDefinedIndicator1

public boolean isUserDefinedIndicator1()
Returns whether this column has the User Defined Indicator 1 set.

Returns:
true if this column has UD1 set, false otherwise
See Also:
setUserDefinedIndicator1(boolean)

isUserDefinedIndicator10

public boolean isUserDefinedIndicator10()
Returns whether this column has the User Defined Indicator 10 set.

Returns:
true if this column has UD10 set, false otherwise
See Also:
setUserDefinedIndicator10(boolean)

isUserDefinedIndicator2

public boolean isUserDefinedIndicator2()
Returns whether this column has the User Defined Indicator 2 set.

Returns:
true if this column has UD2 set, false otherwise
See Also:
setUserDefinedIndicator2(boolean)

isUserDefinedIndicator3

public boolean isUserDefinedIndicator3()
Returns whether this column has the User Defined Indicator 3 set.

Returns:
true if this column has UD3 set, false otherwise
See Also:
setUserDefinedIndicator3(boolean)

isUserDefinedIndicator4

public boolean isUserDefinedIndicator4()
Returns whether this column has the User Defined Indicator 1 set.

Returns:
true if this column has UD1 set, false otherwise
See Also:
setUserDefinedIndicator1(boolean)

isUserDefinedIndicator5

public boolean isUserDefinedIndicator5()
Returns whether this column has the User Defined Indicator 5 set.

Returns:
true if this column has UD5 set, false otherwise
See Also:
setUserDefinedIndicator5(boolean)

isUserDefinedIndicator6

public boolean isUserDefinedIndicator6()
Returns whether this column has the User Defined Indicator 6 set.

Returns:
true if this column has UD6 set, false otherwise
See Also:
setUserDefinedIndicator6(boolean)

isUserDefinedIndicator7

public boolean isUserDefinedIndicator7()
Returns whether this column has the User Defined Indicator 7 set.

Returns:
true if this column has UD7 set, false otherwise
See Also:
setUserDefinedIndicator7(boolean)

isUserDefinedIndicator8

public boolean isUserDefinedIndicator8()
Returns whether this column has the User Defined Indicator 8 set.

Returns:
true if this column has UD8 set, false otherwise
See Also:
setUserDefinedIndicator8(boolean)

isUserDefinedIndicator9

public boolean isUserDefinedIndicator9()
Returns whether this column has the User Defined Indicator 9 set.

Returns:
true if this column has UD9 set, false otherwise
See Also:
setUserDefinedIndicator9(boolean)

populatePersistedMappings

public void populatePersistedMappings()
Internal use only Populate internal persistence mapping.


removeTargetMapping

public void removeTargetMapping(TargetMapping pTargetMapping)
Internal use only Removes a target mapping from this target column.

Parameters:
pTargetMapping - the target mapping to remove

setBusinessRule

public void setBusinessRule(java.lang.String pBusinessRule)
Internal use only Sets the business rule for this target column.
Use InterfaceActionOnTargetColumnSetBusinessRule to set this property.

Parameters:
pBusinessRule - the business rule to be set
See Also:
getBusinessRule()

setCheckNotNullIndicator

public void setCheckNotNullIndicator(boolean pCheckNotNullIndicator)
Internal use only
Sets a new value for the check not null indicator.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the indicator type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.CHECK_NOT_NULL.

Parameters:
pCheckNotNullIndicator - the new value for the check not null indicator
See Also:
isCheckNotNullIndicator(), InterfaceActionOnTargetColumnSetIndicator.InterfaceActionOnTargetColumnSetIndicator(IndicatorType, String, boolean)

setDataType

public void setDataType(OdiDataType pOdiDataType)
Internal use only Sets the data type of the target column.

Specified by:
setDataType in interface IColumn<OdiInterface.TargetDataStore>
Parameters:
pOdiDataType - the data type
See Also:
IColumn.setDataType(oracle.odi.domain.topology.OdiDataType), getDataType()

setEnable

public void setEnable(boolean pEnable)
Internal use only Mapped columns need to have a mapping SQL expression set, which will be executed either on target, either on the Staging Area or on the Source. An enabled TargetColumn with no mapping expression generates a critical error in the interface, thus preventing it from being executed. To set an expression, use InterfaceActionOnTargetMappingSetSql, and to map/unmap columns, use InterfaceActionOnTargetColumnSetEnabled.

Parameters:
pEnable - whether this target column should be mapped
See Also:
isEnable(), InterfaceActionOnTargetColumnSetEnabled

setExecutionLocation

public void setExecutionLocation(OdiInterface.ExecutionLocation pExecutionLocation)
Internal use only Sets the execution location for this target column.
To set the execution location on target columns, use InterfaceActionOnTargetMappingSetLocation.

Parameters:
pExecutionLocation - the new execution location for this target column
See Also:
getExecutionLocation()

setInsertIndicator

public void setInsertIndicator(boolean pInsertIndicator)
Internal use only Sets whether this column will participate in insert operations.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.INSERT.

Parameters:
pInsertIndicator - the new insert indicator
See Also:
isInsertIndicator(), InterfaceActionOnTargetColumnSetIndicator

setLength

public void setLength(java.lang.Integer pLength)
Internal use only Sets the length of the column.

Specified by:
setLength in interface IColumn<OdiInterface.TargetDataStore>
Parameters:
pLength - the length
See Also:
IColumn.setLength(java.lang.Integer), getLength()

setName

public void setName(java.lang.String pName)
For internal use only Sets the name of the target column.

Parameters:
pName - the name of the target column.
See Also:
getName()

setPersisted

public void setPersisted(boolean pPersisted)
Internal use only Sets whether the target column is persisted.

Specified by:
setPersisted in interface IOptionnallyPersistedObject
Parameters:
pPersisted - true if the target column is persisted, false otherwise.
See Also:
IOptionnallyPersistedObject.setPersisted(boolean)

setScale

public void setScale(java.lang.Integer pScale)
Internal use only Sets the scale of the target column.

Specified by:
setScale in interface IColumn<OdiInterface.TargetDataStore>
Parameters:
pScale - the scale
See Also:
IColumn.setScale(java.lang.Integer), getScale()

setTargetSqlMappingExpression

public void setTargetSqlMappingExpression(Expression pTargetSQLMapping)
Internal use only Sets the mapping expression to be executed on target on this target column.
To set this property, use InterfaceActionOnTargetMappingSetSql with a null DataSet (provided that you really want to set a mapping on the target).
Note that mappings should comply with a few basic rules:
- mappings executed on the SOURCE should not reference columns from different physical schemas,
- mappings executed on the SOURCE should reference at least a source column, otherwise the target column should be manually assigned to a SourceDataStore using InterfaceActionOnTargetMappingSetAttachedDataStore,
- mappings executed on the TARGET should not reference any source columns, since the source columns are not available on the target.

Parameters:
pTargetSQLMapping - the expression for the target mapping
See Also:
getTargetSqlMappingExpression()

setUnderlyingOdiColumn

public void setUnderlyingOdiColumn(OdiColumn pColumn)
Internal use only Sets the underlying column for this target column.

Parameters:
pColumn - the new underlying OdiColumn
See Also:
getUnderlyingOdiColumn()

setUpdateIndicator

public void setUpdateIndicator(boolean pUpdateIndicator)
Internal use only Sets whether this column will participate in Update operations.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.UPDATE.

Parameters:
pUpdateIndicator - the new insert indicator
See Also:
isUpdateIndicator(), InterfaceActionOnTargetColumnSetIndicator

setUpdateKeyIndicator

public void setUpdateKeyIndicator(boolean pUpdateKeyIndicator)
Internal use only Sets whether this column will be used as key when doing updates on the target datastore.
To set this property, use InterfaceActionOnTargetColumnSetIndicator with the type InterfaceActionOnTargetColumnSetIndicator.IndicatorType.UPDATE_KEY.

Parameters:
pUpdateKeyIndicator - the new insert indicator
See Also:
isUpdateKeyIndicator(), InterfaceActionOnTargetColumnSetIndicator

setUserDefinedIndicator1

public void setUserDefinedIndicator1(boolean pUserDefinedIndicator1)
Internal use only Sets whether this column has the User Defined Indicator 1 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=1.

Parameters:
pUserDefinedIndicator1 - the new insert indicator
See Also:
isUserDefinedIndicator1(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator10

public void setUserDefinedIndicator10(boolean pUserDefinedIndicator10)
Internal use only Sets whether this column has the User Defined Indicator 10 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=10.

Parameters:
pUserDefinedIndicator10 - the new insert indicator
See Also:
isUserDefinedIndicator10(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator2

public void setUserDefinedIndicator2(boolean pUserDefinedIndicator2)
Internal use only Sets whether this column has the User Defined Indicator 2 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=2.

Parameters:
pUserDefinedIndicator2 - the new insert indicator
See Also:
isUserDefinedIndicator2(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator3

public void setUserDefinedIndicator3(boolean pUserDefinedIndicator3)
Internal use only Sets whether this column has the User Defined Indicator 3 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=3.

Parameters:
pUserDefinedIndicator3 - the new insert indicator
See Also:
isUserDefinedIndicator3(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator4

public void setUserDefinedIndicator4(boolean pUserDefinedIndicator4)
Internal use only Sets whether this column has the User Defined Indicator 4 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=4.

Parameters:
pUserDefinedIndicator4 - the new insert indicator
See Also:
isUserDefinedIndicator4(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator5

public void setUserDefinedIndicator5(boolean pUserDefinedIndicator5)
Internal use only Sets whether this column has the User Defined Indicator 5 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=5.

Parameters:
pUserDefinedIndicator5 - the new insert indicator
See Also:
isUserDefinedIndicator5(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator6

public void setUserDefinedIndicator6(boolean pUserDefinedIndicator6)
Internal use only Sets whether this column has the User Defined Indicator 6 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=6.

Parameters:
pUserDefinedIndicator6 - the new insert indicator
See Also:
isUserDefinedIndicator6(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator7

public void setUserDefinedIndicator7(boolean pUserDefinedIndicator7)
Internal use only Sets whether this column has the User Defined Indicator 7 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=7.

Parameters:
pUserDefinedIndicator7 - the new insert indicator
See Also:
isUserDefinedIndicator7(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator8

public void setUserDefinedIndicator8(boolean pUserDefinedIndicator8)
Internal use only Sets whether this column has the User Defined Indicator 8 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=8.

Parameters:
pUserDefinedIndicator8 - the new insert indicator
See Also:
isUserDefinedIndicator8(), InterfaceActionOnTargetColumnSetUD

setUserDefinedIndicator9

public void setUserDefinedIndicator9(boolean pUserDefinedIndicator9)
Internal use only Sets whether this column has the User Defined Indicator 9 set.
To set this property, use InterfaceActionOnTargetColumnSetUD with UDNumber=9.

Parameters:
pUserDefinedIndicator9 - the new insert indicator
See Also:
isUserDefinedIndicator9(), InterfaceActionOnTargetColumnSetUD

Oracle® Data Integrator Java API Reference
11g Release 1 (11.1.1.3.0)

E17060-01

Copyright © 2010, Oracle and/or its affiliates. All rights reserved.