I am trying to load csv file into table , but performance is very very very slow , File is comma delimited with 6 million rows , lookup table is feed generated ID and it inserts into table
help me the changes to loaded faster for 6 million rows ...
In tmap i have below
What's your target DB? Have you tried to set "Use Batch Size" option to activate the batch mode for data processing?