Describe the default join that source qualifier provides?

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 equi join, 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. 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.

Asked on May 30, 2017 in ETL.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.