I have a job that reads data from a csv file and then process it compering it with the data in my database. At this moment my job is processing 700 rows of the csv file in 2min and for me is slow cause i have files with +20.000 rows. My job is something like this:
tFileOutputDelimited > tReplace > 2 DB components to get additional data to the flow > tFilterRow > tMap > DB INSERT
Do somebody know how to improve the performance of the job? When i read the file only using the tFileOutputDelimited it reads the whole file in 3 secs.
Thanks in advance
