Transformation components

Transformation components have both IN-ports and OUT-ports, and apply specific transformations to the data in the transformation stream.

Component	Description
Character Mapper	Replaces characters and strings in an input record. Character Mapper applies replacement mapping to all selected attributes.
Copy Splitter	Unconditionally makes a copy of the input data to each of the output ports.
Data Calculator JavaScript	Performs transformations to every record passed to this component between the IN-port and OUT-port.
Data Splitter JavaScript	Splits an incoming data stream based on input values.
SQL Executor	Use this component to execute one of more custom SQL statements against a database server. SQL Executor is a standalone component without IN or OUT ports.