When using the Change Data Capture log table as a source and a load type of IUD/Slowly Changing Dimensions, rows deleted in the source are flagged as inactive in the target dimension table (ACTIVE=0 and/or END_DATE=today's date).