Expression transformation
Expression transformation is used for row-wise manipulation. For any type of manipulation you wish to do on an individual record, use expression transformation. Expression transformation accepts row-wise data, manipulates it, and passes to the target. The transformation receives the data from the input port and sends the data out from the output ports.
Use the expression transformation for any row-wise calculation, for instance, if you want to concatenate the names, calculate the total salary and convert in upper case, and so on. To understand functionality of expression transformation, let's consider the following scenario:
Scenario for expression transformation: Using the flat file we created in Chapter 3, Understanding Designer Screen and its Components as the source, concatenate FIRST_NAME
and LAST_NAME
to get FULL_NAME
, and get TOTAL_SALARY
from JAN_SALARY
and FEB_SALARY
of individual employee.
We are using expression transformation in this scenario because the...