Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
krayapudi1643622390
Contributor
Contributor

Talend bulk upsert

Hi ,

can you help me with these questions

can’t we use both insert or update during bulk operation ?

 

if so then

how to find out whether record already exits in table or not using tMap ?

Labels (2)
1 Reply
jlolling_kloeckner
Contributor II
Contributor II

PostgreSQL and MySQL tDBOutput components have the option to use insert extensions.

Please take care your table has an appropriated primary key and than you can use the Action on Data: "Insert or update on duplicate key and unique index".

Both database types have such options slightly different implemented but with the same result.