You can join related objects based on existing relationships or custom relationships.

Data Integration

restricts the type of relationships that you can create based on the connection type.

Use the following relationships to join related objects:

Existing relationships

You can use relationships defined in the source system to join related objects. You can join objects with existing relationships for Salesforce, database, and some

Data Integration

Connectors connection types.

After you select a primary object, you select a related object from a list of related objects.

Custom relationships

You can use custom relationships to join multiple source objects. You can create custom relationships for the database connection type.

When you create a custom relationship for database objects, you create an inner, left outer, or right outer join on the source fields that you select.

To join source objects, you add the primary source object in the

Objects and Relationships

table. Then you add related objects, specify keys for the primary and related objects, and configure the join type and operator. For more information about related source objects, see the Source Transformation section in

Transformations

.