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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.