I have a job that is:

tOracle Input > tMap > tTeradataOutput


tOracle Input: contains SQL which renames a column that is a word that is reserved in Teradata.
tTeradataOutput: Commit every 100,000 and Batch Size 10,000

Right now, it is taking about an hour to bring over 200,000 files.

What can be done to speedup transferring the records? I have an index (3 columns) on the Teradata table.

Last edited by talendtester (2010-05-21 22:23:51)