Mapping SQL Expressions to Target Column
You can enter a SQL function in Source Column and have the result of the function mapped to the Target Column. For example, you can enter (FIRST_NAME+MIDDLE_I+LAST_NAME) in the blank Source Column drop-down value to create FULL_NAME in the Target Column.
Note:
Only non-aggregate SQL functions can be mapped to a Target Column.