We have a a number of processes where in we transfer the data from SQL server to TD. We extract he data as files & then dump it using Fastload. Just wanted to know is there any other process we can experiment to make this load any more faster ? The record number is a bit high so takes around significant time.
Hope I made myself clear.
Where is the time being spent? If much of the time is writing / reading the file extract, then consider using Teradata Parallel Transporter, SSIS, or some third-party tool to "pipe" data directly between databases and eliminate the intermediate file.