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.
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.
