I am trying to understand the toracleSCD component for one of my job.
will it allow to enter duplicate record in the table
I tried entering the records twice by executing the same job twice with same input file and it generated two records as below
(ID is generated via sequence)
can you please let me know if this expected from tOraclescd component ?
shud the result be as below
1|John|Belgium|22/06/17|(null) - (No new record to be inserted)
and if there is change in place and a new record gets inserted , will the scd_end date of the previous record will get upated automatically in the job or has to be separately.
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
Test drive Talend's enterprise products.