There is a change in Primary key of a warehouse table holding data up to date. Basically source system added an existing column in the table as a primary key and sequelly the same change need to be amended in warehouse(EDW) as well.
Any structured way of handling this to use the data with old primary keys as well new primary keys
I think a surrogate key or an identity column can help you. Add a column to your table making it the unique primary index. Then reload your table with existing data. Before reloading make sure u have a surrogate key logic being handled by the ETL or declare the primary index as identity column. Thanks