You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented
You need to ensure that the Merge Join transformation works correctly without additional transformations