C
Transformations
This appendix provides a list of the OracleAS InterConnect transformations.
Copy Fields
Copy the source field(s) into the destination field(s).
Parameters:
None
Copy Object
Copy the source object into the destination object.
Parameters:
None
Concat Fields
Concatenate the source field(s) and copy into the destination fields.
Parameters:
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.
Parameters:
delimiter |
The delimiter or string of characters around which the source field should be broken up. |
Set Constant
Copy a constant into the destination fields.
Parameters:
constant |
The constant to be copied. |
True Conditional Lookup XRef
Finds the source field in a cross reference table. If condition is satisfied, copy it into the destination field.
Parameters:
condition |
The condition for this parameter. |
table |
The cross reference table. |
pass through |
When there is no corresponding cross reference, and this parameter is true , the destination field is set to the source field. If this parameter is false , the destination field is set to null. |
True Conditional Lookup DVM
Finds the source field in a domain value map table. If condition is satisfied, copy it into the destination field.
Parameters:
condition |
The condition for this parameter. |
table |
The domain value map table. |
pass through |
When there is no corresponding domain value map and this parameter is set to true , the destination field is set to the source field. If this parameter is set to false , the destinations field is set to null. |
Conditional Copy
Copy the source field(s) into the destination field(s) if expression is satisfied.
Parameters:
expression |
The expression. |
only copy on true |
If this parameter is set to true and the expression evaluates to false , nothing is copied. If this parameter is set to false and the expression evaluates to false , the second input object is copied. |
True Conditional Copy
Copy the source field(s) into the destination field(s) if condition is satisfied.
Parameters:
condition |
The condition for this parameter. |
True Conditional Concat
Concatenate the source field(s) into the destination field if the condition is satisfied.
Parameters:
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 condition is satisfied.
Parameters:
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 field(s) into the destination field(s) if condition is NOT satisfied.
Parameters:
condition |
The condition for this parameter. |
False Conditional Concat
Concatenate the source field(s) into the destination field if the condition is NOT satisfied.
Parameters:
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. |
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.
Parameters:
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 look up a decimal point character. |
To Number
Convert the sign, value, and precision source fields into a number and copy it into the destination field.
Parameters:
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 look up a decimal point character. |
Substring
Copy a substring of the source field into the destination field.
Parameters:
begin index |
The index at which the substring begins. |
length |
An optional length of the substring. |
Char Replace
Replace characters in the source field and copy it into the destination field.
Parameters:
targets |
The string of characters to replace. |
replacements |
The string of replacement characters. |
String Replace
Replace each occurrence of a string in the source field and copy it into the destination field.
Parameters:
targets |
The string of characters to replace. |
replacements |
The string of replacement characters. |
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.
Parameters:
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.
Parameters:
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.
Parameters:
length |
The padding length. |
character |
An optional character to pad with, default is <space> . |
RPad
Pad source field starting from the right for a given length and copy it into the destination field.
Parameters:
length |
The padding length. |
character |
An optional character to pad with, default is <space> . |
Lookup XRef
Lookup the source field in a cross reference table and copy it into the destination field.
Parameters:
table |
The cross reference table. |
pass through |
When there is no corresponding cross reference and this parameter is set to true , the destination field is set to the source field. If this parameter is set to false , the destination field is set to null . |
Delete XRef
Delete the source field from a cross reference table.
Parameters:
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.
Parameters:
table |
The cross reference table. |
pass through |
When there is no corresponding domain value map and this parameter is set to true , the destination field is set to the source field. If this parameter is set to false , the destination field is set to null . |
Truncate
Truncate source field starting from the right for a given length and copy it into the destination field.
Parameters:
length |
The length to truncate. |
Increment
Increment a counter and copy the incremented value into the destination field.
Parameters:
start value |
The initial counter value. |
counter |
Give this counter a name to 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. |
DatabaseOperation
Apply some SQL or PL/SQL operations to the source field(s) and copy the result to the destination field(s). This transformation can be processed on any database, not necessarily 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 executed. 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.
Parameters:
db user |
The database user name. |
db password |
The password of the database user. |
db host |
The hostname of the database. |
db port |
The listener port of the database. |
db sid |
The SID of the database. |
jdbc driver |
The JDBC driver to use (thin or oci ). |
retry count |
The number of retries. |
retry delay |
The delay before each retry in seconds. |
operation |
The SQL or PL/SQL statement of the database operation. |
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>
where <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
|