After connecting the input and output ports for the Application Source Qualifier transformation, double-click the title bar of the transformation and select the Properties tab.
In an Application Source Qualifier transformation, click the button in the Extract Override field.
Click Generate SQL.
Enter the syntax for the join in the WHERE clause immediately after the WHERE.
Enclose Informatica join syntax in braces ( { } ).
When using an alias for a table and the Informatica join syntax, use the alias within the Informatica join syntax.
Use table names to prefix columns names, for example, “table.column”.
Use join conditions supported by the source database.
When entering multiple joins, group joins together by type, and then list them in the following order: normal, left outer, right outer. Include only one right outer join per nested query.
Select port names from the Ports tab to ensure accuracy.