understanding toraclescd component

[vidya821]

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.

Thanks

[Anonymous]

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