Insert or update based on sequence

Highlighted
Five Stars

Insert or update based on sequence

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

Thirteen Stars

Re: Insert or update based on sequence

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

tSEQ.PNG

 

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

-----------

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.