D Transformations

This appendix describes the OracleAS Integration InterConnect transformations.

OracleAS Integration InterConnect Transformations

This section contains the following transformations:.

Copy Fields

Copy the source fields into the destination fields.

Parameters:

None

Copy Object

Copy the source object into the destination object.

Parameters:

None

Concat Fields

Concatenate the source fields, and copy into the destination fields.

Parameter	Description
prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

Expand Fields

Expand the source field into the destination fields.

Parameter	Description
delimiter	The delimiter or string of characters around which the source field should be separated.

Set Constant

Copy a constant into the destination fields.

Parameter	Description
constant	The constant to be copied.

True Conditional Lookup XRef

Find the source field in a cross-reference table. If the condition is satisfied, then copy it into the destination field.

Parameter	Description
condition	The condition for this parameter.
table	The cross-reference table.
pass through	If there is no corresponding cross-reference, and the parameter is true, then the destination field is set to the source field. If this parameter is false, then the destination field is set to null.

True Conditional Lookup DVM

Find the source field in a domain value map table. If the condition is satisfied, then copy it into the destination field.

Parameter	Description
condition	The condition for this parameter.
table	The domain value map table.
pass through	If there is no corresponding domain value map and this parameter is set to true, then the destination field is set to the source field. If this parameter is set to false, then the destinations field is set to null.

Conditional Copy

Copy the source fields into the destination fields if the expression is satisfied.

Parameter	Description
expression	The expression.
only copy on true	If this parameter is set to true and the expression evaluates to false, then nothing is copied. If this parameter is set to false and the expression evaluates to false, then the second input object is copied.

True Conditional Copy

Copy the source fields into the destination fields if the condition is satisfied.

Parameter	Description
condition	The condition for this parameter.

True Conditional Concat

Concatenate the source fields into the destination field if the condition is satisfied.

Parameter	Description
condition	The condition for this parameter.
prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.
suffix	An optional suffix to the concatenated string.

True Conditional To Number

Convert the sign, value, and precision source fields into a number, and copy it into the destination field if the condition is satisfied.

Parameter	Description
condition	The condition for this parameter.
int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.
DVM	An optional domain value map to lookup decimal point character.

False Conditional Copy

Copy the source fields into the destination fields if condition is not satisfied.

Parameter	Description
condition	The condition for this parameter.
condition	The condition for this parameter.
condition	The condition for this parameter.

False Conditional Concat

Concatenate the source fields into the destination field if the condition is not satisfied.

Parameter	Description
condition	The condition for this parameter.
prefix	An optional prefix to the concatenated string.
separator	The separator, a string of characters, that separate source fields in the concatenated string.

False Conditional To Number

Convert the sign, value, and precision source fields into a number and copy it into the destination field if condition is not satisfied.

Parameter	Description
condition	The condition for this parameter.
int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.

To Number

Convert the sign, value, and precision source fields into a number, and copy it into the destination field.

Parameter	Description
int length	The number of digits before the decimal point excluding the sign.
dec length	The number of digits after the decimal point.
character	The padding character.

Substring

Copy a substring of the source field into the destination field.

Parameter	Description
begin index	The index at which the substring begins.
length	An optional length of the substring.
begin index	The index at which the substring begins.

Char Replace

Replace characters in the source field, and copy it into the destination field.

Parameter	Description
targets	The string of characters to replace.
replacements	The string of replacement characters.
targets	The string of characters to replace.

String Replace

Replace each occurrence of a string in the source field, and copy the replacement into the destination field.

Parameter	Description
targets	The string of characters to replace.
replacements	The string of replacement characters.
targets	The string of characters to replace.

LTrim

Delete source field characters starting from the left until a character from the set is found, and copy the remaining string into the destination field.

Parameter	Description
characters	The string of characters to seek that stop the deletion.
characters	The string of characters to seek that stop the deletion.
characters	The string of characters to seek that stop the deletion.

RTrim

Delete source field characters starting from the right until a character from the set is found, and copy the remaining string into the destination field.

Parameter	Description
characters	The string of characters to seek that stop the deletion.
characters	The string of characters to seek that stop the deletion.
characters	The string of characters to seek that stop the deletion.

LPad

Pad source field starting from the left for a given length, and copy it into the destination field.

Parameter	Description
length	The padding length.
character	An optional character to pad with, default is <space>.
length	The padding length.

RPad

Pad source field starting from the right for a given length, and copy it into the destination field.

Parameter	Description
length	The padding length.
character	An optional character to pad with, default is <space>.
length	The padding length.

Lookup XRef

Lookup the source field in a cross-reference table, and copy it into the destination field.

Parameter	Description
table	The cross-reference table.
pass through	If there is no corresponding cross-reference and this parameter is set to true, then the destination field is set to the source field. If this parameter is set to false, then the destination field is set to null.
table	The cross-reference table.

Delete XRef

Delete the source field from a cross-reference table.

Parameter	Description
table	The cross-reference table.
table	The cross-reference table.
table	The cross-reference table.

Lookup DVM

Look up the source field in a domain value map table, and copy it into the destination field.

Parameter	Description
table	The domain value map table.
pass through	If there is no corresponding domain value map and this parameter is set to true, then the destination field is set to the source field. If this parameter is set to false, then the destination field is set to null.
table	The domain value map table.

Truncate

Truncate source field starting from the right for a given length, and copy it into the destination field.

Parameter	Description
length	The length to truncate.
length	The length to truncate.
length	The length to truncate.

Increment

Increment a counter, and copy the incremented value into the destination field.

Parameter	Description
start value	The initial counter value.
counter	The name of the counter. The name should distinguish it from other counters that may be at different values at a given time and may have a different step size.
step size	The increment size.

Lookup

Find equivalent of an item in the Lookup table and copy its value in the destination field.

Parameter	Description
table	The name of the table in which Item will be looked up.
item	The name of the item to be looked up.

AddTransformation

Add user-defined information in the header component of the OAI message.

Parameter	Description
field	The field to be added.
value	The value of the added field.

DatabaseOperation

Apply SQL or PL/SQL operations to the source fields, and copy the result to the destination fields. This transformation can be processed on any database, including the hub or database adapter instance. Connect to the database given by the connectivity parameters and bind the input variables to the corresponding bind variables of the SQL or PL/SQL given by the operation parameters.

The statement is then run. Upon successful execution, the results are copied to the destination field of the transformation. The connection to the database is then closed and the result of the transformation is returned.

Parameter	Description
db user	The database user name.
db password	The password of the database user.
db host	The hostname of the database.

Note: For the PL/SQL type of transformation, the following syntax of the PL/SQL statement is assumed: IN parameters are specified with a ?I OUT parameters are specified with a ?O:<T> IN/OUT parameters are specified with a ?IO:<T> <T> is a single character type specifier denoting the type of the variable. Valid variable values are: S: String I: Integer F: Float D: Double T: Date B: Binary