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!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema