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

😎