how to insert data into postgresql without replacing any duplicate records

[MAfridi1650945823]

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 ,

[Anonymous]

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

[Anonymous]

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.