Study tips 70-463

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 add the new capability to all the packages without copying the code between packages

Which transformation types should you use?

Which three actions should you perform in sequence?

Which Change Type values should you select?

Which task should you select?

Which data flow transformation should you use?

You need to ensure that the Merge Join transformation works correctly without additional transformations

Which stored procedure should you use?

How should you develop the data flow?