MongoDB Connector > Mappings and mapping tasks with MongoDB > Joining multiple objects

Joining multiple objects

When you create a Source transformation, you can select multiple MongoDB objects as the source type and then configure an advanced relationship to combine the tables.

Perform the following steps to join multiple objects in a Source transformation:

1In the Source transformation properties, select the Source Type as Multiple Objects.

2From the Actions menu, select Add Source Object, and then select the source object that you want to add from the displayed list.

3From the Related Objects Actions menu, and select the Advanced Relationship option to define the relationship between the tables.

Note: The Add Related Objects option is not applicable.

The following image shows an advanced relationship condition defined between MongoDB tables:

This image shows the advanced relationship condition.

Note: You can join only two source tables. You must define only the join condition, not the complete join query.