If the session uses sorted relational data, use

n

:

n

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

When you use a pass-through partition at the Joiner transformation, maintain sorted data in the mapping. When you use a hash auto-keys partition point, you maintain the sort order by passing all sorted data to the Joiner transformation in a single partition. Add a key-range partition point at the Source Qualifier transformation that contains all source data in the first partition. When you pass sorted data in one partition, the Integration Service redistributes data among multiple partitions with a hash function and joins the sorted data.

The following image shows sorted relational data that pass through a single partition to maintain the sort order: