Perfomance tuning : Tmap Component in Talend
The settings mostly depend on the volume of data you require for processing while applying a join, i.e., If Lookup table have few rows: select "Lookup model" as Load Once . This will load lookup data into memory only once and uses that to compare all other records from parent table. This is a faster option as memory loading is less IF lookup table have large amount of data : Talend cant store the lookup table data in memory. you will get java heap space Execption. To resolve this issue follow the below steps open tmap go to lookup table click on tmap settings select the value for store temp data property to True click on ok In Tmap properties basic settings set Temp Data Directory path by browsing folder Go to Advance settings set max buffer size(nb of row) to some value based on lookup condition data type