• That is not unlike how the many-to-many relationship is handled in the OLTP database from which I am pulling the data. In this approach every time a new Type 2 change row is added to Dim.Name, a corresponding row would be added to Dim.AddressName, with a query or expression to associate the existing AddressSurrogateKey with the new NameSurrogateKey. Is that right?

    And the reporting tool might vary, but mostly would be Reporting Services.