When you configure a Source transformation to read from multiple Salesforce objects, you can select related objects based on existing relationships in Salesforce.
On the Source page in the mapping, select the Salesforce connection.
Select
Multiple Objects
as the
Source Type
.
In the
Objects and Relationships
section, click
Add Source Objects
from the menu.
In the
Select Source Object
window, select the source object that you want to add, and then click
OK
.
To add related objects, select the source object, right-click menu, and then click
Add Related Objects
.
In the
Select Related Object
window, select the related object that you want to add, and then click
OK
.
For example, the following image shows the list of related objects that have existing relationships with the Account parent object:
The following image shows the selected parent-child objects in the Source transformation:
ASK INFAPreview
