Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rathesh
Contributor
Contributor

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

Labels (2)
1 Reply
vapukov
Master II
Master II

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

0683p000009M09l.png

 

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