After you create a transformation, you can configure it. Every transformation contains the following common tabs:
Name the transformation or add a description.
Add and configure ports.
Configure properties that are unique to the transformation.
Some transformations might include other tabs, such as the Condition tab, where you enter conditions in a Joiner or Normalizer transformation.
When you configure transformations, you might complete the following tasks:
Define the columns of data that move into and out of the transformation.
In some transformations, define input or output groups that define a row of data entering or leaving the transformation.
Enter SQL-like expressions in some transformations that transform the data.
Define local variables.
Define local variables in some transformations that temporarily store data.
Override default values.
Configure default values for ports to handle input nulls and output transformation errors.
Enter tracing levels.
Choose the amount of detail the Integration Service writes in the session log about a transformation.