Use to specify if the relationship in the dataset will be a lookup or a join. More
See Lookups and Joins for more information on these components.
This dialog can be restored by using the Bypass Create Lookup or Join user parameter.
Note:
Without this dialog, dragging between attributes creates a join by default. To create a lookup, hold the Shift key while dragging between attributes."Create a Join or a Lookup" in the "Creating Joins and Lookups" section in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator