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 shouldn't need 2 subjobs. Why not just have 1 subjob with your new data feeding your tMap as Main and your existing data (in the scd) as your lookup. Join on whatever key you use. When there is a join, you need to update your existing record (use an output to update this record setting the end date as the date of the new record. You also have an output for your new record (where you will set the start date as the same date as the end date of the updated record). If there is no join, you only send the new record. 

[Anonymous]

Hi @rhall

Thanks for your response, I go through the your previous comment and implement but i am getting Variable error.

Below is snapshot:

[Anonymous]

Hi @shong please take a look at this.

[Anonymous]

Can you click on the Code tab (in the bottom left corner of your workspace window), then look for red rectangles and click on them to see the code in error. Give us a few examples of the errors.

[Anonymous]

please take look at this on error.

[Anonymous]

Now getting this error.

[Anonymous]

Hera are all details:

Please tell me if i am using wrong expression as well and putting condition in expression builder box for update and old record.

Thanks,

Arpit

[Anonymous]

ok i am fix the variable problem but now job looks like stuck cause condition and expression.

can anyone have look on this:

Thanks,

Arpit

[Anonymous]

these are snapshots for insert, update and old dim_table, check if action on data option: