Merge transformations : This merges the data from two sources and creates a single output. You can use these transformations to break the data flow path and create a different error path. After the error is handled, you can merge it back to the main data flow. For implementing this sort, you need to sort the data, and the metadata should be the same for two different paths.
Union all transformations : This works similar to merge transformation but the only difference is that you do not have to sort the data. It will merge the data from different sources into a single output.
