When you create a Source transformation, you can select multiple PostgreSQL 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, select the
Source Type
as
Multiple Objects
.
From the
Actions
menu, select
Add Source Object
.
In the
Select Source Object
window, select the source object that you want to add, and then click
OK
.
From the
Actions
menu, select
Advanced Relationship
.
In the
Advanced Relationship
window, click
Add Object
to add more objects.
In the
Select Source Object
window, select the source object with which you want to define a relationship, and then click
OK
.
In the
Advanced Relationship
window, select the required fields, and set the conditions or specify a query to define a relationship between the tables.
ASK INFAPreview
