How to get start date for new record and set end date for previous record

[Anonymous]

Hi All,

I am implementating SCD type2 without using SCD component in talend but i am not getting Startdate and End as par my requirement.

Requirement is:

1.If data is fresh then start date will set as current date and end date as null.

2.if data is already exist in DB but one attribute changed that data then what it should do for previous record end date should be as current date and for new updated record start date as current date and end date will be null.

Please Tell me where m going wrong.

Thanks,
Arpit

Here my screenshots:

[Anonymous]

You should understand that logic. At the moment you have a compilation error which needs to be resolved. Did you resolve the compilation error?