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