Available for relational targets. Connection used by the transformation. Click in the right side of the field to change the connection.

The following image shows the location of the dropdown button to click:

Available for relational and customized targets.

The Developer tool lets you convert data by passing it from port to port. Sometimes a conversion causes an overflow of numeric data or truncation of strings in columns that contain characters. For example, passing data from a Decimal (28, 2) to a Decimal (19, 2) port causes a numeric overflow. Likewise, if you pass data from a String(28) port to a String(10) port, the Data Integration Service truncates the strings to 10 characters.

When a conversion causes an overflow, the Data Integration Service, by default, skips the row. The Data Integration Service does not write the data to the reject file. For strings, the Data Integration Service truncates the string and passes it to the next transformation.

Select this option to include all truncated and overflow data between the last transformation and target in the session reject file. The Data Integration Service sends all truncated rows and any overflow rows to the session reject file or to the row error logs, depending on how you configure the session.

Directory where the reject file exists. Default is the RejectDir system parameter.

File name of the reject file. Default is <output_file_name>.bad.

If multiple partitions write to the flat file target, each partition writes to a separate reject file named <output_file_name><partition_number>.bad.