You can join two related entities that have either one to many or many to one relationships. For example, join the account and contact entities to retrieve all accounts and the corresponding contacts.

You cannot join unrelated entities, more than two entities, or join entities that have many to many relationships. If you join entities that have many to many relationships, the PowerCenter Integration Service retrieves only those records that satisfy this condition.

The following table describes the entity join information:

Property	Description
Primary Entity	Primary entity to join in the Application Source Qualifier.
1:N Relationships	The corresponding relationships between the primary entity and the linked entity.
Join Type	Type of join that can be inner or outer join. Default is outer join.
Primary Entity Join Attribute	The primary entity join attribute.
Linked Entity Join Attribute	The linked entity join attribute.
Join Expression	Displays the adapter-specific relationship you specify to join two related entities. You can copy this expression and use it when you specify the related entity join information at run-time.