https://community.qlik.com/t5/Talend-Studio/Talend-bulk-upsert/m-p/2340920#M108912 <P>PostgreSQL and MySQL tDBOutput components have the option to use insert extensions.</P><P>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".</P><P>Both database types have such options slightly different implemented but with the same result.</P> Wed, 19 Apr 2023 10:22:20 GMT jlolling_kloeckner 2023-04-19T10:22:20Z https://community.qlik.com/t5/Talend-Studio/Talend-bulk-upsert/m-p/2340919#M108911 <P>Hi ,</P><P>can you help me with these questions</P><P>can’t we use both insert or update during bulk operation ?</P><P>&nbsp;</P><P></P><P></P><P>if so then</P><P>how to find out whether record already exits in table or not using tMap ?</P><P></P><P></P> Wed, 19 Apr 2023 07:46:04 GMT https://community.qlik.com/t5/Talend-Studio/Talend-bulk-upsert/m-p/2340919#M108911 krayapudi1643622390 2023-04-19T07:46:04Z https://community.qlik.com/t5/Talend-Studio/Talend-bulk-upsert/m-p/2340920#M108912 <P>PostgreSQL and MySQL tDBOutput components have the option to use insert extensions.</P><P>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".</P><P>Both database types have such options slightly different implemented but with the same result.</P> Wed, 19 Apr 2023 10:22:20 GMT https://community.qlik.com/t5/Talend-Studio/Talend-bulk-upsert/m-p/2340920#M108912 jlolling_kloeckner 2023-04-19T10:22:20Z