| Joiner transformation is a active and connected. |
| Joins data from different databases or flat file systems or from same sources. |
| |
| Join Type :: |
| |
- Normal Join
The PowerCenter Server discards all rows of data from the master and detail source that do not match, based on the condition.
- Master Outer Join
A master outer join keeps all rows of data from the detail source and the matching rows from the master source. It discards the unmatched rows from the master source.
- Detail Outer Join
A detail outer join keeps all rows of data from the master source and the matching rows from the detail source. It discards the unmatched rows from the detail source.
- Full Outer Join
A full outer join keeps all rows of data from both the master and detail sources.
|
| cannot use a Joiner transformation :: |
| |
- Either input pipeline contains an Update Strategy transformation
- You connect a Sequence Generator transformation directly before the Joiner transformation
|
| |
| Perform joins in a database when possible |
- Create a pre-session stored procedure to join the tables in a database.
- Use the Source Qualifier transformation to perform the join.
|
| |
