You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode
You need to design a consolidated dimensional structurethat will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented