tmysql - how to close record permanently

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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.