Add an option in the SCD Type 2 loader to allow for a Change Current Indicator flag with a value of '1' for the most current record even if this record has been expired.
When using full loads and selecting to "expire records in target but not in source" then the change current indicator gets set to '0' for all records not in source. With this logic the change current indicator is only '1' if valid_to_dttm also indicates an active record. The relationship is 1:1 and the flag doesn't add any additional information.
Business reason for this request
Having a Change_Current_Ind='1' for the most current record added - whether expired or not - would allow for row level selection of such records. Such selection can for example be required when preparing data for fraud detection (eg. including also all accounts closed in the last 2 months).
Without such a flag additional processing is required (eg. a SQL group by with a having clause) to retrieve such records. For large data volumes (eg. Finance or Telco) the additional processing time is significant.
I know of at least one big site which won't be able to use the SCD Type 2 loader "out-of-the-box" without this added behaviour for loading the Change Current Indicator flag.