topic Re: How to fill the update's date column in Talend Studio

How to fill the update's date column

Anonymous — Wed, 19 Feb 2020 14:08:18 GMT

Hello,

I have to populate a table with data and fill the creation and update date columns.

Creation date : the date in which the lign has been recorded in the table

Update date : the date in which the lign has been updated

I know how to fill the creation date with the tmap by joining the source table with the destination table and filter with the ID==0 which means that the lign does not exist yet in the table.

For the update date, i have tried to do the same thing by filtring with ID!=0, the problem is talend updates all the ligns of the update date's column with the current date even if they are no change in the records !

Is their a way to do this beside the inner join reject because i have a complex flow and I don't want to repeat it just for the update.

Thank you in advance

Re: How to fill the update's date column

cmendels — Wed, 19 Feb 2020 18:43:10 GMT

Based on your description, it seems that your job is only checking to see whether the id already exists, not whether the record has been updated. You'll need to have some way of flagging which records are updated and add that to your filter.

Re: How to fill the update's date column

Anonymous — Thu, 20 Feb 2020 09:00:01 GMT

Do you know a way to flag the records in Talend ?

Re: How to fill the update's date column

nivedhitha — Fri, 21 Feb 2020 19:21:46 GMT

@imanegh ,

Can you provide a screenshot of your tMap?