If the session uses sorted flat file data, use

n

:

n

partitions for the master and detail pipelines. You can add a pass-through partition or hash auto-keys partition at the Joiner transformation.

If you add a pass-through partition at the Joiner transformation, maintain the sort order in mappings. If you add a hash auto-keys partition point at the Joiner transformation, you can maintain the sort order by passing all sorted data to the Joiner transformation in one partition. When you pass sorted data in one partition, the Integration Service maintains the sort order when it redistributes data with a hash function.

To allow the Integration Service to pass all sorted data in one partition, configure the session to use the sorted file for the first partition and empty files for the remaining partitions.

The Integration Service redistributes the rows among multiple partitions and joins the sorted data.

The following image shows sorted file data passed through one partition to maintain sort order: