When you join relational data, use 1:

n

partitions for the master and detail pipeline. When you use 1:

n

partitions, you cannot add a partition point at the Joiner transformation. If you use

n

:

n

partitions, you can add a pass-through or hash auto-keys partition at the Joiner transformation. If you use a hash auto-keys partition point, you must configure partitions to pass all sorted data in the first partition to maintain sort order.