understanding toraclescd component

vidya821 — Thu, 22 Jun 2017 13:06:43 GMT

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 ?

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.

Thanks

Re: understanding toraclescd component

Anonymous — Fri, 30 Jun 2017 04:06:12 GMT

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

topic Re: understanding toraclescd component in Talend Studio

understanding toraclescd component

Re: understanding toraclescd component