https://community.qlik.com/t5/Talend-Studio/tmysql-how-to-close-record-permanently/m-p/2299255#M71615 Hi <BR />SCD component does not support deleted data. Do you want to mark valid_to_dttm as 'D' or delete these data in dimension table? <BR /> <BR />Regards <BR />Shong <BR /> Tue, 09 Jan 2018 10:17:43 GMT Anonymous 2018-01-09T10:17:43Z https://community.qlik.com/t5/Talend-Studio/tmysql-how-to-close-record-permanently/m-p/2299254#M71614 <P>I am able to create scd type job using valid_from_dttm and valid_to_dttm. It is working fine.&nbsp;</P> <P>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).&nbsp;I am unable to set value to valid_to_dttm for such soft deletion.</P> <P>Please advice how to handle this.</P> Sun, 07 Jan 2018 04:32:42 GMT https://community.qlik.com/t5/Talend-Studio/tmysql-how-to-close-record-permanently/m-p/2299254#M71614 Anonymous 2018-01-07T04:32:42Z https://community.qlik.com/t5/Talend-Studio/tmysql-how-to-close-record-permanently/m-p/2299255#M71615 Hi <BR />SCD component does not support deleted data. Do you want to mark valid_to_dttm as 'D' or delete these data in dimension table? <BR /> <BR />Regards <BR />Shong <BR /> Tue, 09 Jan 2018 10:17:43 GMT https://community.qlik.com/t5/Talend-Studio/tmysql-how-to-close-record-permanently/m-p/2299255#M71615 Anonymous 2018-01-09T10:17:43Z