Enter a command that each writer thread runs separately. Each thread sends the target data to the command when the mapping runs. Each thread runs the same command with a different set of data.

When you enter the command, you must consider the operating system on which the mapping runs. For example, if you enter the command

cat > /log/data/myoutput.txt

, multiple threads write to the same file which could cause an operating system error. If you enter the command

cat >> /log/data/myoutput.txt

, multiple threads append data to the same file which is less likely to cause an operating system error.

To send the target data for a single partition to a command, select command for the

Output Type

property, and select no merge for the

Merge Type

property. Enter a command for the

Command

property.

Enter a merge command that processes the merge data for all writer threads. The Data Integration Service must use a concurrent merge type for a command to process merge data. Each thread concurrently sends target data to the merge command when the mapping runs. The merge command runs once with all of the data. The command might not maintain the order of the target data.

To send merge data for all partitions to a merge command, select command for the

Output Type

property, and select concurrent for the

Merge Type

property. Enter a command for the

Merge Command

property.