topic Re: Compare one table 24h before and after in Talend Studio

Compare one table 24h before and after

Anonymous — Mon, 14 May 2018 08:18:24 GMT

*Sorry for my english, i'm french ^^*

Hello,

I'm a beginner in Talend and i try to make a jobs to work with VtigerCRM.

So, we have 1 table in AS/400 Database and we want to synchronize datas with Vtiger (AS/400 is the main database) all the 24 hours.

So, with tVtigerCRM Module in talend, we can make one type of action per module (Insert, Update, Delete), and i want to use the right action at the right time (the picture is attached to the post).

I do not know how to determine, for each record, whether it has been modified, deleted (id that no longer exists), or it's a new one ...

I don't know if you really understood what I want to do, I can not explain well what I would like to do...

Thank you !

Re: Compare one table 24h before and after

manodwhb — Mon, 14 May 2018 08:51:24 GMT

@Minos,you can tick the Key in tmap for the business coulmn based on that you can insert /update/delete.

Re: Compare one table 24h before and after

manodwhb — Mon, 14 May 2018 08:58:42 GMT

@Minos,you need to compare the As/400 DB sorce table with Target table then only you can figure out that the record is new or existing.

Re: Compare one table 24h before and after

Anonymous — Mon, 14 May 2018 09:16:39 GMT

@manodwhb, ok, and how can i compare 2 tables in Talend ? (Sorry i'm realy beginner ^^)

Re: Compare one table 24h before and after

manodwhb — Mon, 14 May 2018 09:20:35 GMT

@Minos,you can do with tMap or tJoin..

please find the blelow links to

https://www.talend.com/resources/configuring-joins-in-tmap/

Re: Compare one table 24h before and after

Anonymous — Mon, 14 May 2018 09:23:28 GMT

Oh ok thanks, i will try this

Re: Compare one table 24h before and after

manodwhb — Tue, 22 May 2018 08:28:32 GMT

@Minos,did it help?

Re: Compare one table 24h before and after

Anonymous — Tue, 22 May 2018 10:03:08 GMT

@manodwhb,

Finally I did something else, I've already imported all the data, and for comparison I'm just in the process. I was thinking rather to copy the bases on CSV files (12000 lines approximately it's not very heavy) then to check them using the module tFileCompare, the problem and that I would like to separate into subjob (update or insert) according to the answer of the tFileCompare, it is possible ?

Thank you

Re: Compare one table 24h before and after

manodwhb — Tue, 22 May 2018 10:24:17 GMT

@Minos,you can separate the flow since again you need to do lookup with target to derive new record or udpdated record.

Re: Compare one table 24h before and after

manodwhb — Wed, 23 May 2018 13:45:21 GMT

@Minos,Did it help you?

Re: Compare one table 24h before and after

Anonymous — Wed, 23 May 2018 14:02:33 GMT

Sorry I had another problem in the evening yesterday and I just corrected the problem...
I don't really understand how to separate the flow according to an entry condition in fact...

Re: Compare one table 24h before and after

manodwhb — Thu, 24 May 2018 06:05:16 GMT

@Minos,can you post your job and expalin where do you have issue?