Skip navigation links

oracle.dmt.jdm.transform
Interface OraExpressionTransform

All Superinterfaces:

OraTransformation

public interface OraExpressionTransform

extends OraTransformation

OraExpressionTransform is used to specify per attribute SQL expressions for tranformation and optional reverse transformation of the data. For example, to specify data transformation for age attribute as a logarithm function with base 10 and the transformed attribute must be renamed as log_age, call the following method:

addAttributeExpression("age", "log(10, age) as log_age", "power(10, log_age)")

Here the first parameter "age" is input attribute that you wanted to transform, the second parameter "log(10, age) as log_age" is the SQL expression to specify the transformation and renaming of the input attribute and the third parameter "power(10, log_age) as age" is the SQL experssion to specify optinal reverse transformation to get back to the original data.

Since:

OJDM 11.1.0

Nested Class Summary

static interface

OraExpressionTransform.OraExpressionElement OraExpressionElement is used to encapsulate the per attribute expression inverse expression details.

Method Summary

void	addAttributeExpression(java.lang.String inputAttr, java.lang.String expression, java.lang.String inverseExpression) Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression.
void	addAttributeExpression(java.lang.String inputAttr, java.lang.String expression, java.lang.String inverseExpression, java.lang.String attrSpec) Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression and attrSpec.
java.util.Map	getAttributeExpressionMap() Returns a map of the overridden attributes that contains the key as the input attribute name and the value as the OraExpressionElement instance.
void	removeAttributeExpression(java.lang.String inputAttrName) Removes the specified attribute's OraExpressionElement from the settings.

Methods inherited from interface oracle.dmt.jdm.transform.OraTransformation

getExcludeColumnList, getTransformInputData, getTransformOutputData, isOutputView, setExcludeColumnList, setTransformInputData, setTransformOutputData

Method Detail

addAttributeExpression

public void addAttributeExpression(java.lang.String inputAttr,
                                   java.lang.String expression,
                                   java.lang.String inverseExpression)

Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression.

Parameters:

inputAttr -

expression -

inverseExpression -

addAttributeExpression

public void addAttributeExpression(java.lang.String inputAttr,
                                   java.lang.String expression,
                                   java.lang.String inverseExpression,
                                   java.lang.String attrSpec)

Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression and attrSpec. The attrSpec field is used to specify additional information and actions for an attribute. You can specify the value NOPREP for attribute_spec.

Parameters:

inputAttr -

expression -

inverseExpression -

attrSpec -

Since:

11.1.0.7

getAttributeExpressionMap

public java.util.Map getAttributeExpressionMap()

Returns a map of the overridden attributes that contains the key as the input attribute name and the value as the OraExpressionElement instance.

Returns:

Map

removeAttributeExpression

public void removeAttributeExpression(java.lang.String inputAttrName)

Removes the specified attribute's OraExpressionElement from the settings.

Parameters:

inputAttrName -

Skip navigation links