Four Stars

tmysql - how to close record permanently

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.

Community Manager

Re: tmysql - how to close record permanently

SCD component does not support deleted data. Do you want to mark valid_to_dttm as 'D' or delete these data in dimension table?

Talend | Data Agility for Modern Business