topic Re: Update and Insert the records in the existing table in Talend Studio

Update and Insert the records in the existing table

Anonymous — Thu, 09 May 2019 04:28:26 GMT

Hi guys,

I have design a job as in attached image.

Firstly, I clear the table and insert data.

Secondly, I update or insert data to the table but the process do not follow the order.

The first inputDB in starting state and can not finish.

Pls advice on this case, thank you so much.

Re: Update and Insert the records in the existing table

bhagyarekha — Thu, 09 May 2019 05:00:03 GMT

Hi ,

As per my knowledge you should do insertion job, then you should go for on subjob trigger for next updating records

but when i see your screen shot,my question is what is the need for updating the records when the same input you are inserting in the table.

can you explain me what is your requirement

Regards

rekha

Re: Update and Insert the records in the existing table

Anonymous — Thu, 09 May 2019 05:19:45 GMT

Thank you so much for quick reply.

I have two tMap output like in screenshot.

One i do check string length for Street, one I do for LastName.

I want to update row if record with same CUSTNO have both Street and LastName needed to be trimmed.

Re: Update and Insert the records in the existing table

bhagyarekha — Thu, 09 May 2019 08:31:55 GMT

just give me sample input and out put you are expecting.both condition are mandatory to check?

see on first condition street >32 means lastname should be any length right, those you want to insert?or if you want to check lastname length go condition in column.

Use insert or update,first it inserts record in table,if the record is their it updates next