sithusithu

 Profile Answers by sithusithu 

• Jan 24th, 2006

 

The Joiner transformation supports the following join types, which you set in the Properties tab:

• Normal (Default)
• Master Outer
• Detail Outer
• Full Outer

Cheers,

Sithu

halgai

 Profile Answers by halgai 

• Oct 8th, 2007

 

Equijoin on a key common to the sources drawn by the SQ.

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 21st, 2009

 

Default join is Normal Join/Inner Join/Equi-Join

Sumithav29

 Profile Answers by Sumithav29 

• Jun 12th, 2009

 

When you join related tables in one Source Qualifier transformation, the Integration Service joins the tables based on the related keys in each table.
This default join is an inner equijoin, using the following syntax in the WHERE clause:

Source1.column_name = Source2.column_name.

The columns in the default join must have: A primary key-foreign key relationship and matching datatypes.

Vikas Dhakne

• Aug 8th, 2016

 

Source Qualifier transformation supports following types of joins:
1.Normal/Equi join
2.Left Outer Join
3.Right Outer Join

Aaradhya

• Nov 10th, 2016

 

The Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full Outer
Default join is Normal Join/Inner Join/Equi-Join
When you join related tables in one Source Qualifier transformation, the Integration Service joins the tables based on the related keys in each table. This default join is an inner equijoin, using the following syntax in the WHERE clause: Source1.column_name = Source2.column_name.The columns in the default join must have: A primary key-foreign key relationship and matching datatypes.