You can use
n
:
n
partitioning with Joiner transformations with sorted or unsorted input. When you use
n
:
n
partitioning for a Joiner transformation, you create
n
partitions in the master and detail pipelines. When the Integration Service processes the join, it compares the rows in a detail partition against the rows in the corresponding master partition, ignoring rows in other master partitions. When processing master and detail data for outer joins, the Integration Service outputs unmatched master rows after it processes the partition for each detail cache.