In the flat file data object advanced properties, set the

Merge Type

property to

No merge

. The Data Integration Service concurrently writes the target output to a separate file for each partition. If you require merged target data, the concurrent merge type optimizes performance more than the sequential merge type.

When multiple threads write to a single directory, the mapping might encounter a bottleneck due to input/output (I/O) contention. An I/O contention can occur when threads write data to the file system at the same time. When you configure multiple directories, the Data Integration Service determines the output directory for each thread in a round-robin fashion.

Configure the output file directories in the advanced properties for the flat file data object. Use the default TargetDir system parameter value if an administrator entered multiple directories separated by semicolons for the

Target Directory

property for the Data Integration Service in the Administrator tool. Or, you can enter a different value to configure multiple output file directories specific to the flat file data object.