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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads