In order to implement our naming convention we added a custom surrogate key field to our tables of the DWH (e.g. SK_Employee).
The value of this new column is set to the DW_ID from the valid table (using script).
On large tables this has a performance penalty (extra update for empty SK-field).
It would be nice to have the option to rename the DW_ID … which would solve this entire issue.
Any chance this can be implemented in TX DWA ?