understanding toraclescd component

Seven Stars

understanding toraclescd component

Hi,

 

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)

ID|Name|Place|SCD_START|SCD_END

1|John|Belgium|22/06/17|(null)

2|John|Belgium|22/06/17|(null)

 

can you please let me know if this expected from tOraclescd component ?

or

shud the result be as below

ID|Name|Place|SCD_START|SCD_END

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.

ThankstOracleSCD component Schema editor.png

Community Manager

Re: understanding toraclescd component

Hi
Set the Surrogate keys to anther column which is different from source key or remove it there is no Surrogate column in your table.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch