Additional information about join operations - Cloud

Talend Cloud Pipeline Designer Processors Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development > Designing Pipelines
EnrichPlatform
Talend Pipeline Designer

The Join processor allows you to apply four different types of join operations to your hierarchical data.

Inner join

This type of join operation is used to:

  • match the values that are common between two Datasets
  • create a result set with all the pairs that match
The result set is determined as follows:
If the join statement is satisfied (Dataset L matches Dataset R) If the join statement is not satisfied
All matching records are combined and returned in the result set Non-matching records are ignored

Left outer join

This type of join operation is used to:

  • match the values that are common between two Datasets AND retain all the values that exists in the left Dataset
  • create a result set combining these records
The result set is determined as follows:
If the join statement is satisfied (everything that is in Dataset L + matches in the two Datasets) If the join statement is not satisfied
All records in the left Dataset as well as the matching records between Dataset left and Dataset right are combined and returned in the result set Non-matching records are ignored

Right outer join

This type of join operation is used to:

  • match the values that are common between two Datasets AND retain all the values that exists in the right Dataset
  • create a result set combining these records
The result set is determined as follows:
If the join statement is satisfied (everything that is in Dataset L and R + matches in the two Datasets) If the join statement is not satisfied
All records in the left Dataset as well as the matching records between Dataset left and Dataset right are combined and returned in the result set Non-matching records are ignored

Full outer join

This type of join operation is used to:

  • retain all the values that match in the left and right Datasets
  • create a result set combining these records
The result set is determined as follows:
If the join statement is satisfied (everything that is in Dataset L + matches in the two Datasets) If the join statement is not satisfied
All records in the left Dataset as well as the matching records between Dataset left and Dataset right are combined and returned in the result set Non-matching records will be listed in the result set as NULL