I have a file, which will update the output table on the basis of key columns and conditions. Now, the requirement is to get the unused records of the file, which will not update the table.
One way is to do the inner join between file and table and fetch the reject records, but this is creating huge performance issue, because the table is around 30 million and it is affecting hugely.
Can someone suggest how to do it without degrading performance.
If you use the option "Reload at each row" on tMap you may get rows from table 1 after 1 for each record from input file. Should be acceptable if input file is not too large.
However what if you don't filter anything and place tMap after your DbOutput component to catch updated record? (not able to try at this time)
