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:
    1. In the Source transformation properties, select the Source Type as Multiple Objects.
    2. From the Actions menu, select Add Source Object, and then select the source object that you want to add from the displayed list.
    3. From 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.