Well, you need to do some data transformation somewhere, let's say between the source and staging or staging and destination. To choose between these two you need to check your...
We are using something similar and MERGE is just perfect for this as mentioned. In our solution we are creating a work table and load the data in it....