When you create a Source transformation to run mappings in advanced mode, you can
select multiple MongoDB V2 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, select the
Advanced Relationship
option to define the relationship between the tables.
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
