Insert or update based on sequence

[Rathesh]

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

[vapukov]

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