/
Join Partition vs Join Key

Join Partition vs Join Key

Rule name

Join Partition vs Join Key

Parallel Job

Yes

Server Job

-

Job Sequence

-

Description

Identifies Join stages where the join key does not match the partitioning key

Description

Parallel Join stages require that their input data are partitioned using the same key(s) as those being used for the Join condition.

If this is not the case then data rows which fulfil the Join condition may not be joined as they will be propagated along different partitions.

Actions

Ensure the Join key and partition keys are aligned.

Related content

Audit Annotation
Audit Annotation
Read with this
Oracle Connector not using Partition Read
Oracle Connector not using Partition Read
More like this
Adjacent Transformers
Adjacent Transformers
Read with this
(v6 2) Link Partitioner Stage
(v6 2) Link Partitioner Stage
More like this
Link Partitioner Stage
Link Partitioner Stage
More like this
Link Partitioner Stage
Link Partitioner Stage
More like this

© 2015-2024 Data Migrators Pty Ltd.