Insert/update new records with tmap

Four Stars

Insert/update new records with tmap

Hi Team, 

I am very new to Talend, can someone help me on this. 

We have a table in source system with 6 lakhs records and loaded this data into target DB as a bulk load. 

Every day we have few records added to this table, for this, I have used tmap with inner join and rejecting rows loading into the target table. 

While doing this, its taking lot of time in this transaction (total 6.3 lakhs records with inner join and rejected rows move to the target table) to fetch the rejected rows and load into the target. 


Please suggest how we can improve the performance for this. 



Seven Stars

Re: Insert/update new records with tmap

Hi Jayrapolu,


you can try to increase the "Max buffer size" in tMap "Advanced settings" .


Best regards,




Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.