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
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
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.