History - [SCD Is Tombstone] - Option Push data last active record into Tombstone record

Could another option be created for deletion in History tables.

Either the option to push all the data from the lastest active record into the tomstone record

or a field [SCD Last Active Record] that acts like an indicator that this record was the last active record before the deletion.

This way the last active record is easily selectable.

In some of our sources we don't have a reliable enough date we can use to match with dimensions to find the correct surrogate key. We therefore want to display the latest active record of a dimension.     


Please sign in to leave a comment.