In Runtime, different transformations that have the same source schema and target schema cannot run together. Running multiple transformations with the same source and target schemas may cause potential data issues in the target. In such situations, you can merge multiple transformations into one and run it. You can also customize the mappings and expressions of the merged transformation to suit your requirement.
On the Transformation View, press the Ctrl key, and select the transformations that you want to merge.
Note: Only transformations with the same source data store can be merged.
Right-click and select Merge.
The merged transformation is created. You can change the default name of the transformation as required.
Note: For any conflicts, such as Runtime error handling policy, Occurs mapping, or expressions in a merged transformation, DDW generates an error message prompting the users to solve the conflict.