5

Surrogate Key creation

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 ?

9 comments

Please sign in to leave a comment.