I know, I know. The source data shouldn't have deleted records. They should be marked inactive. However I can see that not happening due to third party systems, odd business practices, general bad practices, etc.
I've already got the three cardinal fields on all my tables regardless of what type of SCD is being used - EffectiveDt, ExpirationDt, CurrentRow.
Does anyone have a best practice for this kind of situation? Here's my thought on it and luckily I'm early into the process of building the warehouse:
Use the ExpirationDt for the date the record was deleted and leave the CurrentRow as 'Current'.
Pros and cons of this? I don't want to delete records from the warehouse since historically they did exist.