Insert or update based on sequence

Rathesh — Sun, 14 Oct 2018 19:38:50 GMT

I want to perform insert or update operation in to a oracle table. But the primary key value of the table gets incremented by a sequence. So how to call that sequence during insert operation and not to call the sequence during update operation?. I have found a way for this by calling the sequence inside a trigger which will be used to inserted the value into primary key field, so that i don't need to include that in the mapping. But problem is i am not able to create a new trigger into production environment and i want it to be done using talend

Re: Insert or update based on sequence

vapukov — Sun, 14 Oct 2018 22:36:21 GMT

you can delete you column from standard schema and add new additional column in advanced settings tab, whee You can use NEXTVAL

it will definitely work for insert, for update need check - think it will be ok, but need test

topic Insert or update based on sequence in Talend Studio

Insert or update based on sequence

Re: Insert or update based on sequence