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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog