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.
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.