Hi Vinuta,
- Are you using any lookup in tMap? if yes, you can opt for using FileSystem for lookup data storage in place of memory...
- Whether your output DB is on same machine where redshift is available? if not, then network delay could be an issue
- What are other processes are consuming memory when you execute the talend job and how much memory is available for talend?
- What is the batchsize in output, try tweaking that..
- Have you tried restarting Talend?
Vaibhav