Component: TRANSFORM DATA

The following table describes the fields in the Transform Data.

Table 11-17 Fields in the Transform Data and their Descriptions

Field	Description
Rule Name	Refers to the Data transformation name that was defined in the Post Load Changes window of Data Management Tools framework. Select the rule name from the drop-down list.
Parameter List	Is the list of parameters defined in Data Transformation check in which the parameters must be in the same order as in the definition and must be separated by a comma (“,”). Irrespective of the data type of the parameter defined in the procedure. The parameter specified through the front-end does not require to be specified within quotes (' '). Note: Commas are used as delimiters for parameter values internally by the ICC Batch component. Ensure that commas are not used in any of the parameter values, that is, “a, b, c” should not be a parameter value in the list of parameter values being passed to the TRANSFORM DATA task. For example, if the parameter values to this task are required to be passed as (val1, val2, (a, b, c), val4), the correct way would be to pass these values as (val1, val2, (abc), val4). You can use any other character as a separator.

Field

Description

Rule Name

Refers to the Data transformation name that was defined in the Post Load Changes window of Data Management Tools framework. Select the rule name from the drop-down list.

Parameter List

Is the list of parameters defined in Data Transformation check in which the parameters must be in the same order as in the definition and must be separated by a comma (“,”). Irrespective of the data type of the parameter defined in the procedure. The parameter specified through the front-end does not require to be specified within quotes (' ').

Note: Commas are used as delimiters for parameter values internally by the ICC Batch component. Ensure that commas are not used in any of the parameter values, that is, “a, b, c” should not be a parameter value in the list of parameter values being passed to the TRANSFORM DATA task. For example, if the parameter values to this task are required to be passed as (val1, val2, (a, b, c), val4), the correct way would be to pass these values as (val1, val2, (a*b*c), val4). You can use any other character as a separator.