Informatica Common Component Source qualifier User Defined Join

User defined join:

Entering a user-defined join is similar to entering a custom SQL query. However, you only need to enter the contents of the WHERE clause instead of the entire query.

When you add a user-defined join, the Source qualifier transformation includes the settings in the default SQL query. However, if you modify the default query after you add a user-defined join, PowerCenter will only use the query that is defined in the SQL query properties in the Source qualifier transformation.

You can include mapping parameters and variables in a user-defined join. When you include a string mapping parameter or variable, use the string identifier that applies to the source system. For most databases, you apply single quotation marks around string parameters or variable names.

When you include datetime parameters or variables, you may want to change the date format to match the format used by the source. PowerCenter will convert datetime parameters and variables to strings based on the source system.

Informatica Common Component Source qualifier User Defined Join