When you create a flat file target at run time, the

mapping

task creates the physical target the first time the mapping runs based on the fields from the upstream transformation. In subsequent runs, if the target file name does not change, the

mapping

task overwrites the target file. If the file name changes between mapping runs, the

mapping

task creates a new target.

Data Integration

creates the target in the default connection directory.

You can configure a static or dynamic file name for the target file. A static file name can include a time stamp. A dynamic file name uses an expression to generate the file name when the

mapping

task runs.

Data Integration

can write to a delimited or fixed-width target file. By default, when

Data Integration

creates a target at run time using a fixed-width file format, it rounds data that uses the Decimal or Double data types. You can choose to skip rounding the data for Decimal and Double data types. Data Integration doesn't round delimited data by default.

By default,

Data Integration

writes fields to the target in the order in which they enter the transformation. However, you can specify a different order. You might want to reorder fields for certain financial reports or to follow the specific field order that a downstream system requires. Configure the field order on the

Target Fields

tab.

When you create a flat file target at run time, you can't link the target fields to the upstream transformation. If you want to reduce the number of unused fields in the target, configure field rules in the Target transformation or in the upstream transformations.