You can join the source definition of a detail tree that you import and a non-detail record source definition in an Application Source Qualifier transformation. The Designer can perform this default join if both of the following conditions are true:

When you join an imported detail tree source definition with a non-detail record source definition related to the detail record, the Designer uses the relationship between the records to create the default join.

When designing a mapping, you can connect a detail tree, detail record, and non-detail record to the same Application Source Qualifier. However, if you do not require data from the detail record, you can leave the detail record unconnected. The Designer validates the mapping as long as the detail record is associated with the Application Source Qualifier performing the join.

For example, the mapping in the following figure joins the tree CONS_ACCT and a non-detail record ACCT_TYPE_TBL:

The mapping contains the detail record GL_ACCT_CONS_VW. The Designer validates the default join of the tree and non-detail record sources because the detail record is an associated source, even though the detail record is not connected to the Application Source Qualifier.

The following figure shows the GL_ACCT_CONS_VW detail record associated with the Application Source Qualifier transformation: