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.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.