topic how to insert data into postgresql without replacing any duplicate records in Talend Studio

how to insert data into postgresql without replacing any duplicate records

MAfridi1650945823 — Fri, 15 Nov 2024 22:52:55 GMT

Hey all ,

I'm newbie in Talend , I want to know that how can i insert all records in PostgreSQL without replacing or deleting any duplicate records ,

Re: how to insert data into postgresql without replacing any duplicate records

Anonymous — Mon, 30 May 2022 03:36:54 GMT

Hello @Mahnoor Afridi, go to the advanced settings panel of tPostGresqlOutput, check the 'use fields' option and select 'Insertable' option for all columns.

Regards

Shong

Re: how to insert data into postgresql without replacing any duplicate records

Anonymous — Thu, 02 Jun 2022 23:09:34 GMT

Hello,

Create a staging table load the data into that table.

Then either use a Row component to insert the records to the target or an tELTMap but we also have SCD components if you want to keep your historical data.

We also have insert or update but that would "replace" the existing records.