When you create a Source transformation, you can select multiple Elasticsearch 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.
You can join only two source tables. You must define only the join condition, not the complete join query.
ASK INFAPreview
