In a Mapping, you can easily consult all the potential results returned by a join condition, when its execution location is set on "Source".
- Right click on the join
- Choose Action
- Select the operation you want to perform
This will generate the corresponding request in a SQL Explorer window:
You can also perform this on multiple joins. Simply select multiple joins with the 'Ctrl' key before right clicking on one of them:
