Merge Join Transformation || SSIS Transformation
The Merge Join Combine to sorted data into one output using the FULL, LEFT or INNER JOIN
You can configure the Merge Join transformation in the following ways:
Specify the join is a FULL, LEFT, or INNER join.
Specify the columns the join uses.
Specify whether the transformation handles null values as equal to other nulls.
For example, you can use a LEFT join to join a table that includes customer information with a table that lists the phone of customer. The result is a table that lists all customers and their phone numbers.
Note: If null values are not treated as equal values, the transformation handles null values like the SQL Server Database Engine does.
This transformation has two inputs and one output. It does not support an error output
And the properties window looks like this, here we need to set which type of Join we need to perform the dataset(Left outer, right outer or inner) it’s the same what we use in any RDBMS.
Смотрите видео Merge Join Transformation || SSIS Transformation онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Bhaskar Berry 29 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4 раз и оно понравилось lik людям.