Foreign Key Relations on surrogate keys

As per request from a partner it should be possible to physically create the FK relation. Since it is best practice not to have the natural key as PK I suggest we implement the creation of FKs only when surrogate keys are in use. This way we will already have the correct PK which is the DW_Id.

1 comment

Please sign in to leave a comment.