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

  • Data Integration
1 REPLY
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