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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.