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.