I am able to create scd type job using valid_from_dttm and valid_to_dttm. It is working fine.
Source table is making soft delete of record by setting record_type='D' in source table. How to close such record permanently in my dimension table (SCD type). I am unable to set value to valid_to_dttm for such soft deletion.
Please advice how to handle this.