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]

Your tMap should be checking if row7 data is null. The userId from row6 will not be null.....because that is Main data. You need to check the lookup data for nulls. If you get an error saying that int cannot be null, that is true. Just tick the "Nullable" tick box for that column in the schema and it will change it to an Integer. An int is primitive and can never be null. An Integer is a class and can be null.

[Anonymous]

still its not giving me any result. 

[Anonymous]

You're still checking for 0 instead of null. row7 values will be null if there is no join

[Anonymous]

If i am putting Null then it will give me error

[Anonymous]

You need to ensure your userId column is set to Nullable for row7.  

[Anonymous]

Please have a look on this

[Anonymous]

If you are still getting a compilation error you need to take another look at the Code tab to look for errors. Take a screenshot of the errors

[Anonymous]

still getting error on typemismatch

[Anonymous]

It looks like you have changed the job and the filtering for your tMap outputs. It says you are mixing int with booleans in the error message.

[Anonymous]

can you just clarify me which type expression i ll write for :

insert new record

updated record

inactive record