topic How to get last modified date for row in tmap in Talend Studio

How to get last modified date for row in tmap

gt0731 — Sat, 16 Nov 2024 05:29:07 GMT

Hi everyone ,

We have two column in our data model . that is

LAST_UPDATE_TIME = calculate only when row get updated in tmap
CREATE_DATE = only When row get inserted first time in tmap

How do i calculate these column for each of my table at tmap.

if there is any better alternatives using talend, kindly share the process

Any help on this would be much appreciated

Re: How to get last modified date for row in tmap

David_Beaty — Tue, 25 Jun 2019 20:58:32 GMT

Hi,

First of all, if LAST_UPDATE_TIME is null, then you know it's CREATE_DATE.

If both columns are populated, then I'd suggest you use the Talend routine TalendDate with a methof of compareDate().

Have a look at this link

Re: How to get last modified date for row in tmap

Anonymous — Wed, 26 Jun 2019 16:21:52 GMT

Hi @gt0731 ,

I believe you have two different flows from a tMap one for update and another for insert.

If not, you can create two different flows, and whenever you insert the Update Date column will be null and whenever you update the Update column will hold the value of current TimeStamp.

In the update flow, no need to provide the Create date column, you can chose your keys, based on which you will insert/update.

Thanks and Regards,

Subhadip

Re: How to get last modified date for row in tmap

gt0731 — Thu, 27 Jun 2019 18:55:52 GMT

No, We do not have 2 flows for insert and update.

we use one flow only and based on key matching rows and in target selecting action - insert or update.

-How do we maintain Last_update_time timestamp column here.

Any help on it would be much appreciated ?

Re: How to get last modified date for row in tmap

Anonymous — Thu, 27 Jun 2019 19:30:43 GMT

Hi @gt0731 ,

In this case, you should lookup with your target table with the keys in tMap.

Whenever keys are not present in the table, that means it is insert only so Update Timestamp is Null.

Whenever keys are present, the Update Timestamp should be Current Timestamp.

This logic you can write in tMap(if else condition based on key presence).

Best way would be to have two flows for insert and update.

Thanks and Regards,

Subhadip