History - change [SCD Is Current] field to reflect current state

At the moment, the [SCD Is Current] field on history tables contains "1" for records that have been deleted from the source system.

Since those records do not belong to the current state of the data (i.e. the actual data in the source table), they should not be marked as "Current".

Could you change the logic to let the [SCD Is Current] field reflect the actual state of the data (So "0" for deleted records)?




Please sign in to leave a comment.