I would prefer a separate staging table for each of the different versions of customer.
Then I would look ate combined table with the conformed customer dimension.
I would use merge to get the final table.
Not sure if the above is ok for your volumes. You would really need to add more detail.
E
😎