Merge Transformation || SSIS Transformation
Merge Transformation in SSIS is used to merge two inputs (such as tables or files) and produce one output
Merge Transformation is very useful when we want to merge the error path data (after handling the errors) and normal data. This transformation uses key column values to insert the data into destination columns.
Yes the first question any SQL SERVER developer can ask is, these operations can very well be done in T-SQL query, Why using it in SSIS?, well the answer is, T-SQL can be used only when you are working with data which resides in SQL SEVER Tables, but what if the data is coming from different database itself like ORACLE or MYSQL or Flat File or XML or EXCEL.
For example, We split the data using Conditional Split Transformation in SSIS as per the condition. After performing few more operations on them we want to merge them back. In these situations we can use Merge Transformation to Merge them back.
NOTE: Merge Transformation will produce only one output and it does not support error output.
By including the Merge transformation in a data flow, you can perform the following tasks:
• Merge data from two data sources, such as tables and files.
• Create complex datasets by nesting Merge transformations.
• Remerge rows after correcting errors in the data.
The Merge transformation is similar to the Union All transformations. Use the Union All transformation instead of the Merge transformation in the following situations:
• The transformation inputs are not sorted.
• The combined output does not need to be sorted.
• The transformation has more than two inputs.
Смотрите видео Merge Transformation || SSIS Transformation онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Bhaskar Berry 29 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1 раз и оно понравилось lik людям.