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:
In the Source transformation properties, select the
Source Type
as
Multiple Objects
.
From the
Actions
menu, select
Add Source Object
, and then select the source object that you want to add from the displayed list.
From the
Related Objects Actions
menu, and select the
Advanced Relationship
option to define the relationship between the tables.
The
Add Related Objects
option is not applicable.
The following image shows an advanced relationship condition defined between MongoDB tables:
You can join only two source tables. You must define only the join condition, not the complete join query.
ASK INFAPreview
