Define the various Join Types of Joiner Transformation.

• In a normal join , the Integration Service discards all rows of data from the master and detail source that do not match, based on the join condition.
• 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.
• 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.
• A full outer join keeps all rows of data from both the master and detail sources.