Open the Source Qualifier transformation, and click the Properties tab.
In a Source Qualifier transformation, click the button in the User Defined Join field.
In an Application Source Qualifier transformation, click the button in the Join Override field.
Enter the syntax for the join.
Do not enter WHERE at the beginning of the join. The Integration Service adds this when querying rows.
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.
ASK INFAPreview
